Help with wait command in a trigger

• Thuan Pham-224808

  Old Hand

  Points: 329

  More actions

  January 9, 2007 at 8:41 am

  #368715

  Hi,

  I have a trigger that will send a person an email when an event happen. However, I need the SQL server to wait 5 minitues before sending the email (please don't ask why). Please help.

   

  Thuan

• PW-201837

  SSC-Insane

  Points: 20805

  More actions

  January 9, 2007 at 8:53 am

  #682041

  Create a queue table to hold the details of the email, and have the trigger insert records to this table, along with a timestamp of when the item was queued.

  Then create a SQL Agent job that runs periodically to check queue items that have been queued more than 5 minutes and email them.

   

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  January 9, 2007 at 9:13 am

  #682050

  And run the job every 2 minutes at least so that at most there is a 6m59s delay before the queuing and execution.

• Thuan Pham-224808

  Old Hand

  Points: 329

  More actions

  January 9, 2007 at 9:17 am

  #682053

  Thank you very much for the helpful suggestions so far.

  Thuan Pham