SQL Server Performance Forum – Threads Archive

creating and runing jobs

Can anyone tell me how to run a proc every night at 11 pm???
thanks

The easiest way would be to create a job using EM, add a step that calls the stored procedure and add a nightly schedule. Otherwise you have to write a script to do it. You will find examples in BOL.

As suggested refer to Books Online for SP_START_JOB or scheduling jobs via Enterprise Manager to accomplish the task. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>