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
tech2010Asked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
RiteshShahConnect With a Mentor Commented:
yes, perfectly OK.
0
 
tech2010Author Commented:
i am not registered on sqlservercentral.com so please tell me something else. thanks
0
[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

 
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
All Courses

From novice to tech pro — start learning today.