SQL Server Performance Forum – Threads Archive
creating and runing jobsCan 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.