Time bound triggers

• Chand00

  SSCertifiable

  Points: 6466

  More actions

  January 21, 2009 at 1:41 am

  #129633

  Hi,

  do we have any time bound triggers in sql server 2005 ie they should get execute at particular point of time.

  Thanks

  Chandra Mohan N

  [font="Verdana"]Thanks
  Chandra Mohan[/font]

• brainy

  SSCrazy

  Points: 2445

  More actions

  January 21, 2009 at 1:53 am

  #930159

  There is no time bound triggers as for my knowledge. But what is your requirement, can you explain more.

• NitinPatel31

  Hall of Fame

  Points: 3721

  More actions

  January 21, 2009 at 2:10 am

  #930166

  There is no such trigger. You can use Job instead.

  Regards,
  Nitin

• brainy

  SSCrazy

  Points: 2445

  More actions

  January 23, 2009 at 12:48 am

  #931667

  Hey .. I got an idea...

  Try using

  WAITFOR

  {

  DELAY 'time_to_pass'

  | TIME 'time_to_execute'

  | [ ( receive_statement ) | ( get_conversation_group_statement ) ]

  [ , TIMEOUT timeout ]

  }

  you can execute the trigger at specified time. Use this inside your trigger.

  I dont know how it works.

  I hope it will help you.

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  January 23, 2009 at 8:30 am

  #931822

  brainy (1/23/2009)

  ---

  Hey .. I got an idea...

  Try using

  WAITFOR

  {

  DELAY 'time_to_pass'

  | TIME 'time_to_execute'

  | [ ( receive_statement ) | ( get_conversation_group_statement ) ]

  [ , TIMEOUT timeout ]

  }

  you can execute the trigger at specified time. Use this inside your trigger.

  I dont know how it works.

  I hope it will help you.

  Nooooooo! Please do not use the WaitFor statement in a trigger, it WILL KILL your system.

  Explain what you need to do and we will suggest solutions.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question

• NitinPatel31

  Hall of Fame

  Points: 3721

  More actions

  January 23, 2009 at 9:24 am

  #931880

  I am agree with Jack. WAITFOR.... will kill the system as it will not complete the transaction until trigger gets executed. (correct me if I am wrong).

  Chandramohann,

  I guess your purpose is to perform some operation like clearing something (delete some temp data..etc..). then you can use Jobs. If not then please let us know why do you want time bound trigger?

  Regards,
  Nitin