Solved

Is it possible to make a backup of SQL scheduled tasks

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

[Webinar] Disaster Recovery and Cloud Management

Learn from Unigma and CloudBerry industry veterans which providers are best for certain use cases and how to lower cloud costs, how to grow your Managed Services practice in IaaS clouds, and how to utilize public cloud for Disaster Recovery

Question has a verified solution.

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

In this article I will describe the Copy Database Wizard 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.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

920 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now