Function Sleep in SQL Server???

[Guest_imported]

I need some help on SQL Server.
I need to create a trigger on the update of a particular field in a table.
This trigger has to perform some action after an hour since this field is updated.
Java has a sleep function, does SQL also have something like that.

Thanks and Regards,
Parul

 

[ColinM]

There is a WAITFOR command (See BOL for details)
Not sure you would want to put this in a trigger, as I think this just pauses SQL Server.

 

[JJayUK]

Can you not store a result from GetDate() in a variable and add one hour to it.

Then set a while loop with an exit clause that says when the current date is greater than or equal to that variable.

I suppose this is a waste of processing power, though.

 

[balves]

I don't think you want to put any sort of delay in a trigger. The original transaction is not complete until all triggers are processed.

One thing you could do is have the trigger insert a row into a jobs table and have another process act on data in that table at some future time.