Delayed execution of a sp

[anu130176]

I want that after I insert a record in a particular table, a stored procedure should execute after a certain period of time say 6 Hrs which will transfer the data inserted to some other table.

I tried using waitfor statement but that doesn't serve my purpose because that will pause the connection to the server for that much amount of time.

Please tell me how do I do it.

Thanx
Anurag

 

[tlbroadbent]

Add a datetime column to the table. When inserting records, set the column to current system datetime. Create a job that executes a stored procedure to move the records that were inserted 6 hours earlier. Schedule the job to run periodically as needed. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.

 

[anu130176]

thanx!!