Post reply

How to move jobs ?

  • 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

  • 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.

  • 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

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply