procedure running as job

• narendra.pola

  Valued Member

  Points: 61

  More actions

  June 2, 2009 at 9:54 pm

  #204968

  Hi,

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

  Thanks,

  Narenndra

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  June 3, 2009 at 8:14 am

  #1004044

  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

• Steve Jones - SSC Editor

  SSC Guru

  Points: 738043

  More actions

  June 3, 2009 at 8:26 am

  #1004057

  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.