June 2, 2009 at 9:54 pm
Hi,
I am new to create jobs please let me know how to create a procedure and register it as a job.
Thanks,
Narenndra
June 3, 2009 at 8:14 am
Start here.
You will create a job, add a step, and put the SP call in the job step. Then create a schedule for the job. The link I provided will walk you through it. Books On Line (BOL) is your friend for things like this.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
June 3, 2009 at 8:26 am
You can select the type of job, the database context (essentially a USE clause) and an owner for the job. These will be used to run the procedure.
There's also a "Parse" button you can use to be sure it's running correctly. I put EXEC in front of the procedures just for style as well.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply