Is there any possiblity to create job execution in stored procedure?

• sram24_mca

  SSCrazy

  Points: 2633

  More actions

  February 10, 2014 at 11:46 pm

  #98958

  Hi,

  Is there any way to create the job design and execution using stored procedure? if yes, please guide me on creating such stored procedures.

  Regards,

  Ram

• Koen Verbeeck

  SSC Guru

  Points: 259105

  More actions

  February 11, 2014 at 12:37 am

  #1687780

  Yes. You can use sp_add_job, sp_add_jobstep and sp_start_job.

  To get an idea of how to use this, right-click on an existing job and script the CREATE statement.

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP

• Igor Micev

  SSC-Dedicated

  Points: 33109

  More actions

  February 11, 2014 at 12:44 am

  #1687782

  Yes you can. As described in previous post.

  The job is actually a SP. So executing/creating a SP from a SP is possible.

  Regards,

  Igor

  Igor Micev,My blog: www.igormicev.com