How to move jobs ?

• AKP

  SSCommitted

  Points: 1753

  More actions

  March 12, 2007 at 11:24 am

  #62133

  Hello,

  We have various automated jobs in production environment.  I need to transfer 2 such jobs with all their dependencies like the stored procedures,tables, local packages. The jobs are running in production environment. After transfer they should run also in Systest Environment. The tables , their data all has to be moved.

  let me know fast.

  Thanks,

   

  AKP

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  Follow

  March 12, 2007 at 12:22 pm

  #694463

  Look up change management articles on this site.  There's no automated way to do this as far as I know.

• Greg Charles

  SSC-Forever

  Points: 45403

  More actions

  March 13, 2007 at 8:51 am

  #694714

  As stated above, there's no comprehensive way to move all those objects.  You'll have to move the tables, stored procedures, packages, and jobs separately. 

  Tables and stored procedures can either be scripted and created in the systest instance or transferred via DTS using the Copy SQL Server Objects task.  Packages can be moved by opening them in DTS Designer and using "Save As" to save them to the systest instance.  Jobs can be scripted and created in the systest instance.

  Greg

  Greg