How can I backup and restore SQL Server 2005 Agent job schedules?
可以将文章内容翻译成中文,广告屏蔽插件可能会导致该功能失效(如失效,请关闭广告屏蔽插件后再试):
问题:
回答1:
the msdb database is where all the jobs live, it is one of the system databases
回答2:
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.