How can I backup and restore SQL Server 2005 Agent job schedules?
如何备份和还原SQL Server 2005代理作业计划？
2 个解决方案
#1
13
the msdb database is where all the jobs live, it is one of the system databases
msdb数据库是所有作业所在的位置，它是系统数据库之一
#2
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.
您还可以将所有作业编写为sql文件，并将其存储在svn或其他源代码控制中，如果您想跟踪更改。
#1
13
the msdb database is where all the jobs live, it is one of the system databases
msdb数据库是所有作业所在的位置，它是系统数据库之一
#2
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.
您还可以将所有作业编写为sql文件，并将其存储在svn或其他源代码控制中，如果您想跟踪更改。