How to move all the SQL Server agent Jobs from one Machine to another machine?

Posted on 2011-04-29
Last Modified: 2012-08-13
We are running many SSIS jobs in  15 SQL server 2008 machine. Now i want to move those jobs  to another new 10 SQL servers 2008 machine.All the server has same operating system (Windows 2008 R2). What is the easiest method? Can I use SSIS?  Please advise me. Thanks
Question by:PKTG
    LVL 22

    Expert Comment

    by:Nico Bontenbal

    Author Comment

    This will help to create only jobs,. But I need to deploy the SSIS package again in the new machine. I am looking easiest and efficient method of Deploying and creating jobs from one machine to another . Thanks.
    LVL 22

    Accepted Solution

    LVL 21

    Expert Comment

    by:Alpesh Patel
    Yes, you can do it using SSIS. There are some maintenance tasks to move SQL objects.
    LVL 8

    Assisted Solution

    You can use the Transfer Jobs SSIS task to do this.
    Please refer to the below article with step by step details:


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive + Dolby Voice = No More Audio Complaints!

    Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

    Suggested Solutions

    SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
    Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    737 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

    22 Experts available now in Live!

    Get 1:1 Help Now