-
Packages in schedules
In sql 2000 if you created a dts package and then scheduled it life was good. however if you went back and changed the dts package and saved it the job that runs the DTS would run the original package, not the changed one. In sql 2005 I created a maintenance package to dbcc all db's and optimize all db's. I went in and noticed that 2 new db's I had created were not included in the "generate tsql from the package" I did a refresh and now they are included. My question is, I saved my changes, now under sql 2005 will the new package be run or the original version?
-
Should run new version. By the way, sql2k runs new version as well. At least on my servers.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|