How to backup SQL Server Agent jobs?

Asked 7/7, 2009 at 18:37 Answered 14/3, 2012 at 6:21

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

Decastro answered 7/7, 2009 at 18:37 Comment(0)

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

Bairn answered 7/7, 2009 at 18:45 Comment(1)

Here's a relevant MSDB article on considerations of restoring MSDB: msdn.microsoft.com/en-us/library/ms190749(v=sql.105).aspx – Civet 5/1, 2017 at 18:16

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.

Reynoso answered 14/3, 2012 at 6:21 Comment(0)