Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Import/Export SQL jobs to different system in SQL 2005

Posted on 2009-05-07
11
1,034 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
ID: 24324616
0
 

Author Comment

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

Expert Comment

by:tbsgadi
ID: 24324661
0
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.

 

Author Comment

by:tech2010
ID: 24324776
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
ID: 24324901
How about backup & restore?
0
 
LVL 31

Expert Comment

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

Expert Comment

by:RiteshShah
ID: 24324920
>>How about backup & restore?<<

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

Expert Comment

by:tbsgadi
ID: 24324951
0
 
LVL 31

Expert Comment

by:RiteshShah
ID: 24324964
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
ID: 24325704
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
ID: 24325718
yes, perfectly OK.
0

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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
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.

861 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