Move SQL Schedule Job to another server

Posted on 2014-08-24
Last Modified: 2016-02-13
Is there a quick way to move all SQL 2008R2 schedule job (not maintenance job) to another new server ?

Question by:AXISHK
    LVL 24

    Accepted Solution

    LVL 3

    Assisted Solution

    do you have a lot? if a few, right click on each, script job as >create to>New query window

    modify script for new server.

    Note that a Sql job can contain many components: saved schedules, email profiles, agents to be notified, SSIS packages to execute, etc.

    If any of these are not present or named differently on the new server, the Job may fail.
    LVL 3

    Expert Comment

    Cool, didn't know there was an SSIS task for job transfers. I would certainly look at using it if I had many jobs to move, say 10 or more.

    Author Comment

    Follow the article to create the transfer job and execute it. Afterwards, It returns error as attached. Any idea ?
    LVL 11

    Expert Comment

    If you can, copy msdb from one to the other.  It's a bit tricky, and you'll want to look into other effects from it than just copying jobs, but you can backup and restore msdb so long as the two servers have the same patch level.
    LVL 24

    Expert Comment

    by:Mohammed Khawaja
    Run the job again and click on the expand button in the error message.  Copy and paste the message to this post.  What is the version of SQL where you are trying to move the jobs to?
    LVL 4

    Expert Comment

    by:Randy Knight, MCM
    Can you post the details of your transfer jobs task and  SQL Server versions and patch levels?

    Also, Idera has a good tool for this, although it's not free.

    It's part of the Idera SQL Admin Toolset.

    Featured Post

    PRTG Network Monitor: Intuitive Network Monitoring

    Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

    Join & Write a Comment

    Over the last 2 years, I have been working on SSIS 2008. Really the tough tasks in SSIS are to deploy packages and pass parameters (Values from outside package). The latter is certainly a headache for developers, particularly for me. We had to ma…
    In couple weeks ago, I encountered an extremely difficult problem while deploying 2008 SSIS packages to a new environment (SQL Server 2014 standard).  My scenario is: We have one C# application that is calling 2008R2 SSIS packages to load text fi…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now