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

How do I backup our SQL Server agent Jobs?


I am running sql server 2005, all the database backups are fine. I have around 20 automated jobs running in the sql server agent. Does anybody know how to back these up? At the moment the only way I can see is to copy each query into a spreadsheet then add each new query in here, is there a better solution? Thanks.
1 Solution
Backup msdb database. Your jobs, steps and schedules are there.

Featured Post

Learn to develop an Android App

Want to increase your earning potential in 2018? Pad your resume with app building experience. Learn how with this hands-on course.

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