procedure running as job

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Peter He » procedure running as job

procedure running as job

Rate Topic

Display Mode

Topic Options

Author

Message

narendra.pola

Posted Tuesday, June 02, 2009 9:53 PM

Forum 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

Jack Corbett

Posted Wednesday, June 03, 2009 8:14 AM

SSChampion

Group: General Forum Members
Last Login: Friday, May 17, 2013 12:22 PM
Points: 10,571, Visits: 11,871

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

Steve Jones - SSC Editor

Posted Wednesday, June 03, 2009 8:26 AM

SSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 3:30 PM
Points: 31,436, Visits: 13,751

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 »

Permissions