How to backup SQL Server Agent jobs?

Question

How can I backup and restore SQL Server 2005 Agent job schedules?

score 14 · Accepted Answer · answered Jul 07 '09 at 18:45

14

the msdb database is where all the jobs live, it is one of the system databases

answered Jul 07 '09 at 18:45

SQLMenace

Here's a relevant MSDB article on considerations of restoring MSDB: https://msdn.microsoft.com/en-us/library/ms190749(v=sql.105).aspx – Dan Bowling Jan 05 '17 at 18:16

score 1 · Answer 2 · answered Mar 14 '12 at 06:21

1

You can also script all the jobs out as a sql file and store them in svn or other source control if you'd like to track changes.

answered Mar 14 '12 at 06:21

sam yi

2 Answers2