• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 235
  • Last Modified:

Is it possible to make a backup of SQL scheduled tasks

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.
1 Solution
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.

Anthony PerkinsCommented:
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.
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.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now