Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1040
  • Last Modified:

Import/Export SQL jobs to different system in SQL 2005

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
tech2010
Asked:
tech2010
  • 5
  • 3
  • 3
1 Solution
 
tech2010Author Commented:
i am not registered on sqlservercentral.com so please tell me something else. thanks
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
tech2010Author Commented:
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
 
tbsgadiCommented:
How about backup & restore?
0
 
RiteshShahCommented:
I am sorry there is no such option still available.
0
 
RiteshShahCommented:
>>How about backup & restore?<<

are you sure backup will take backup of SQL Agent job as well? ;)
0
 
tbsgadiCommented:
0
 
RiteshShahCommented:
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
 
tech2010Author Commented:
is it ok if i right click on each job and generate a script and then run that script on the new server?
0
 
RiteshShahCommented:
yes, perfectly OK.
0

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

  • 5
  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now