Solved

Is it possible to make a backup of SQL scheduled tasks

Posted on 2010-08-18
3
218 Views
Last Modified: 2012-05-10
We recently had development SQL box go down, and ended up having to recreate the SQL scheduled tasks. Is it possible to export to query or make a backup of the SQL tasks that can be transferred to another SQL box?

Thanks in advance.
0
Comment
Question by:ROMAD77
[X]
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
3 Comments
 
LVL 3

Accepted Solution

by:
meagain35 earned 500 total points
ID: 33469470
You should have the following option through management studio.

This will give you the option of saving the task to a file/clipboard/etc... to backup the tasks you have defined.




sql-agent.jpg
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 33470925
If you are referring to the SQL Server Agent jobs, they are saved in the msdb database, so just ensure that database is getting backed up.
0
 
LVL 1

Expert Comment

by:Waynepi
ID: 33474055
You can use the MSDB but it will replace your users too.
1.I suggest you go to SQL server agent and highlight jobs.
2.On the menu list on top select View....Object Explorer Details.....Youll then see all the jobs.
3. Select all(Ctrl+A) and right click....Create script and run it on the new server.
0

Featured Post

Space-Age Communications Transitions to DevOps

ViaSat, a global provider of satellite and wireless communications, securely connects businesses, governments, and organizations to the Internet. Learn how ViaSat’s Network Solutions Engineer, drove the transition from a traditional network support to a DevOps-centric model.

Question has a verified solution.

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

Suggested Solutions

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
I have a large data set and a SSIS package. How can I load this file in multi threading?
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

730 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