Solved

Import/Export SQL jobs to different system in SQL 2005

Posted on 2009-05-07
11
1,031 Views
Last Modified: 2012-05-06
I have two SQL 2005 servers. I wanted to copy all the SQL jobs from one SQL server to another SQL server. please tell me the easist way? Can i this be done using Import/Export data wizard for msdb?

thanks
0
Comment
Question by:tech2010
  • 5
  • 3
  • 3
11 Comments
 
LVL 31

Expert Comment

by:RiteshShah
Comment Utility
0
 

Author Comment

by:tech2010
Comment Utility
i am not registered on sqlservercentral.com so please tell me something else. thanks
0
 
LVL 46

Expert Comment

by:tbsgadi
Comment Utility
0
 

Author Comment

by:tech2010
Comment Utility
by looking this article. I am not sure that if that should be the case for system database. Becuase all it tell you that we can create a script for any database which brings schema and everything. But i am scared to do this way. All i want to do is to pull over my SQL jobs from one physical SQL 2005 box to other physicall SQL 2005?
0
 
LVL 46

Expert Comment

by:tbsgadi
Comment Utility
How about backup & restore?
0
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 31

Expert Comment

by:RiteshShah
Comment Utility
I am sorry there is no such option still available.
0
 
LVL 31

Expert Comment

by:RiteshShah
Comment Utility
>>How about backup & restore?<<

are you sure backup will take backup of SQL Agent job as well? ;)
0
 
LVL 46

Expert Comment

by:tbsgadi
Comment Utility
0
 
LVL 31

Expert Comment

by:RiteshShah
Comment Utility
the link you provided says the same as my link ;) generate the script and move it. not direct export like we used to do for table.
0
 

Author Comment

by:tech2010
Comment Utility
is it ok if i right click on each job and generate a script and then run that script on the new server?
0
 
LVL 31

Accepted Solution

by:
RiteshShah earned 500 total points
Comment Utility
yes, perfectly OK.
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

772 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

9 Experts available now in Live!

Get 1:1 Help Now