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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-25 : 12:17:16
|
| Craig writes "I've created several DTS packages that are dependent on each other to run. Over the course of development, I scheduled each package to run daily at a certain time. When I look at the package logs, individual packages are running multiple times! I know this because I've reschedule packages for different times of the day. I see no direct way to remove the other schedules from a package. Is this a "Known Consequence"?Thanks,Craig" |
|
|
Page47
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2002-04-25 : 12:43:13
|
| "Known Consequence" . . . that's funny.When you schedule a dts package by right clicking and hitting schedule, it is actually creating a job, with one cmd shell step that calls DTSRun.exe with the excrypted credentials needed to run the package. In Enterprise manager, expand SQL Server Agent, Jobs and then delete the offending jobs.<O> |
 |
|
|
|
|
|
Unschedule a DTS Package