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

How do I backup our SQL Server agent Jobs?

Hi,

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.
0
joshuajamie
Asked:
joshuajamie
1 Solution
 
brejkCommented:
Backup msdb database. Your jobs, steps and schedules are there.
0

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