Generate Scripts for SQL Agent Jobs

• Kabelo.

  SSC Enthusiast

  Points: 175

  More actions

  October 18, 2011 at 6:14 am

  #245491

  Hi everyone,

  I want to automatically generate scripts for SQL Agent jobs using a stored procedure, is there a way of doing this.

  regards,

  Kabelo

• Lowell

  SSC Guru

  Points: 323518

  More actions

  October 18, 2011 at 6:25 am

  #1395856

  there are a few script contributions here on SSC that folks have done, that will do what you are asking:

  http://www.sqlservercentral.com/search/?q=script+jobs&t=s

  Lowell

  ---

  --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

• irobertson

  Hall of Fame

  Points: 3695

  More actions

  October 18, 2011 at 6:28 am

  #1395858

  Try looking into sp_addjob:

  http://msdn.microsoft.com/en-us/library/ms182079.aspx

  and sp_addjobstep:

  http://msdn.microsoft.com/en-us/library/ms187358.aspx

  Regards, Iain

• Kabelo.

  SSC Enthusiast

  Points: 175

  More actions

  October 18, 2011 at 7:10 am

  #1395895

  thanks guys

• Devendrakumar

  SSC-Forever

  Points: 42493

  More actions

  October 18, 2011 at 8:21 am

  #1395995

  I want to automatically generate scripts for SQL Agent jobs

  SSMS allows you to generate scripts for jobs (step-by-step) on one click.

• Kabelo.

  SSC Enthusiast

  Points: 175

  More actions

  October 18, 2011 at 9:16 am

  #1396066

  I wanted a way to do that automatically

• Devendrakumar

  SSC-Forever

  Points: 42493

  More actions

  October 18, 2011 at 9:28 am

  #1396084

  Just curious to know more:

  •Is it a periodic / recurring activity?

  •Do the configured jobs change quite often?

• Kabelo.

  SSC Enthusiast

  Points: 175

  More actions

  October 18, 2011 at 10:00 am

  #1396136

  yes,

  I want to create a job that creates the scripts on a daily basis and no the jobs do not change frequently