Post reply

How to create a time based trigger in sql server 2008?

  • August 15, 2013 at 12:11 am

    #296993

    Hi,

    I need How to create a time based trigger in sql server.Pls....

    and thanks 🙂

  • August 15, 2013 at 12:23 am

    #1641651

    You don't give us much information. Can you specify your needs and describe the purpose?

    Perhaps you can create a SQL Agent job that executes your command at the specified time(s)?

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **

  • August 15, 2013 at 6:25 am

    #1641761

    We do need more information. If you are asking for a trigger to execute when a time is reached or elapsed, that's a job. As noted above, SQL Agent would be how you do this.

    Follow me on Twitter: http://www.twitter.com/way0utwest
    Forum Etiquette: How to post data/code on a forum to get the best help
    My Blog: www.voiceofthedba.com

  • August 15, 2013 at 6:37 am

    #1641766

    You could set up a SQL Agent job that triggers at a certain time or at even at fixed intervals. Another methodology I have used is just a stored procedure that uses WAITFOR DELAY or reads from a service broker message queue with a read timeout set or have other processes writing messages at specified intervals.

    Lots of ways, it just depends upon what your requirements are.

    The probability of survival is inversely proportional to the angle of arrival.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply