Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
CanadaDBA
583 Posts |
 Posted - 2008-11-26 : 13:47:44
|
| Using a DTS package, I update SQL jobs in DR box with jobs from prod. This is scheduled and runs automatically. It works fine but imports only the new jobs. If a job has changed or deleted, it doesn't show in DR. How can I synchronize SQL jobs between the two servers?Canada DBA |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-11-27 : 19:07:31
|
| Since you post in SQL 2005, You can use SSIS functionality of Transfer job task . You can choose Copy if doesn't exist or Rewrite option. |
 |
|
|
|
|
|
Synchronize SQL Jobs