Post reply

Transfer SQL jobs

  • December 12, 2003 at 8:51 pm

    #83596

    Hi,

    I want to transfer scheduled jobs from one server to another. First, I generated the jobs script, and then ran that script on the second server. The jobs did get created without any issues,however,when I tried to run them, they failed. Any ideas what happened here?

    Thanks in advance.

    P.S. I don't want to use DTS cause I need to do the same thing on lots servers.

  • December 15, 2003 at 8:46 am

    #486179

    Here is what I did: 1. I craeted db backups, integrity checks and optimizations for system dbs. 2. Genegrated the script for these jobs. 3. Ran that script on the new server.

    The jobs got created,but didn't work(when you run it, SQL says the job fails)

    Thanks again for your time.

  • December 16, 2003 at 10:48 am

    #486462

    The error message didn't give that information, just simply said it failed. Yes. I used the Wizard to create those jobs. You mean if I tranfer the Plan ID as well as the the script, it will work? If yes, what's the best way to tranfer the Plan ID?

    Thanks again for your help!

  • December 16, 2003 at 2:09 pm

    #486525

    http://www.dbazine.com/cook10.shtml

  • December 17, 2003 at 9:07 am

    #486710

    I believe Allen's article is something I am looking for. I will try it out and then let you know how it works.

    Thanks you both again for your time and efforts.

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

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