Timing a trigger or a procedure to execute In SQL Server 2000

[saiprasanthi]

Hi,

I need your help regarding how to time a sql procedure or a trigger to get executed ie., I would like to call the procedure or trigger automatically on a pariticular date and time after satisfying the required conditions. I want this to work SQL Server 2000.


Kindly help me through.

Regards,

Prasanthi

[almaz]

WAITFOR TIME '23:00:00'
exec MyStoredProcedure

[scripto]

you might want to look into creating DTS packages, which you schedule as a job to run when ever you like - a lot simpler i think.

[navamnk]

Directly you can do this using SQL Jobs

[iburyak]

See how I describe the same to another person. Just lazy to rewrite everything again... :)

http://www.thescripts. com/forum/threadnav584597-2-10.html