Moving SQL Agent Jobs

• smallmoney

  SSCarpal Tunnel

  Points: 4378

  More actions

  September 19, 2011 at 8:32 pm

  #390435

  Hi I have one big SQL 2005 instance with 200 sql agent jobs I need to move to another instance. Is there a quicker way then right clicking each individual job--> script job as-->create to.

  I thought I could google some kind of script and extract the jobs out of msdb or something.

  I also have another large SQL 2000 instance I need to migrate too.

  Thanks!

• arr.nagaraj

  SSCertifiable

  Points: 6528

  More actions

  September 19, 2011 at 8:44 pm

  #1383607

  You can do the same. Click on 'Jobs' underneath SQL Server Agent on the management studio.

  On the right side you should see a tab called 'Object Explorer details'. Select all->Right click and script.

  Regards,
  Raj

  http://Strictlysql.blogspot.com

• smallmoney

  SSCarpal Tunnel

  Points: 4378

  More actions

  September 19, 2011 at 9:13 pm

  #1383609

  I owe you a beer! Thanks!

• Perry Whittle

  SSC Guru

  Points: 234040

  More actions

  September 20, 2011 at 10:22 am

  #1383985

  Theres also an SSIS task to do this which works quite well

  -----------------------------------------------------------------------------------------------------------

  "Ya can't make an omelette without breaking just a few eggs"

• R_S

  Ten Centuries

  Points: 1160

  More actions

  September 22, 2011 at 10:54 am

  #1385323

  You can select all jobs at once (from SSMS) and script them out.