Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

procedure running as job Expand / Collapse
Author
Message
Posted Tuesday, June 2, 2009 9:53 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, September 13, 2010 4:45 AM
Points: 9, Visits: 38
Hi,

I am new to create jobs please let me know how to create a procedure and register it as a job.


Thanks,
Narenndra
Post #727855
Posted Wednesday, June 3, 2009 8:14 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 2:53 PM
Points: 10,277, Visits: 13,257
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

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

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
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #728229
Posted Wednesday, June 3, 2009 8:26 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 12:34 PM
Points: 31,181, Visits: 15,626
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.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #728244
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse