Post reply

Transfer Jobs between 2 servers

  • October 7, 2008 at 8:03 am

    #154791

    Heloo,

    I have x number of jobs on my prod server (sql server 2005) which needs to be transferred on to the test server (sql server 2005). what is the most efficient way to do this?

    Thanks

    Mahesh

  • October 7, 2008 at 8:09 am

    #881682

    You could script out the jobs on your prod server and run that script to create them on the test box.

    Gethyn Elliswww.gethynellis.com

  • October 7, 2008 at 8:14 am

    #881687

    Ok. Thanks!!!

  • October 7, 2008 at 8:39 am

    #881719

    I would rather use a task in SSIS. Transfer Job Task in SSIS allows you to transfer jobs easily and even gives options to overwrite if present in destination, and also enable jobs at destination...........It's so simple, you will say WOW..........

    Thanks

  • May 13, 2011 at 12:05 pm

    #1324497

    I got following error when i used SSIS

    [Transfer Jobs Task] Error: Execution failed with the following error: "The SELECT permission was denied on the object 'sysjobs_view', database 'msdb', schema 'dbo'.".

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

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