creating and runing jobs | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

creating and runing jobs

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

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
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.