Solved

Is it possible to make a backup of SQL scheduled tasks

Posted on 2010-08-18
3
216 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
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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

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

Suggested Solutions

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.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

777 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