Post reply

Transferring Job/Schedule Information Between SQL Server instances

  • June 12, 2008 at 9:20 am

    #208295

    Hi,

    Does anyone know how to perform the above. Ideally in a similar way to transferring logins and passwords using the sp_help_revlogin package please?

    Regards

    Craige Brooks

  • June 12, 2008 at 9:29 am

    #827951

    Sorry, I can't see the complete thread title. Could you put you question in the body of your post, please?

    If you want to transfer jobs between instances, the best way is to script them out in SSMS and run the script in the destination instance.

    Greg

  • June 12, 2008 at 11:04 am

    #827997

    If you're in the GUI, you can simply right click the job and select "Script Job as... CREATE to" and pick where you want the script stored. Edit any localization issues in the script as needed.

    I'm pretty sure SSIS has a way to move objects, including jobs, between databases too.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • June 13, 2008 at 1:32 am

    #828289

    Sorry, the title should read Transferring Job/Schedule Information Between SQL Server Instances.

    Thanks for your responses.

    I'll give them a try.

  • June 13, 2008 at 3:02 am

    #828306

    Thanks for that gents, just what I wanted.

Viewing 5 posts - 1 through 5 (of 5 total)

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