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 |
|
wd7179
Starting Member
10 Posts |
 Posted - 2006-03-24 : 14:58:17
|
| I am having an issue with editing currently scheduled jobs. For some reason when I go in to the DTS package and make changes, the job that is scheduled does not get automatically updated. The job Scheduler seems to be running the previous version of the DTS package. I have to delete the job, and schedule the newly edited DTS package to run. That seems to fix the issues with that package going forward.Most of the jobs that are presenting this type of behavior were transfered from a different server. |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-03-24 : 21:26:34
|
| Change the scheduled dtsrun command to use the package name.The job created uses the guid. Probably as this is a new machine it is getting a different guid when you change it so is executing the version with the old guid.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Editing Scheduled Jobs