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 |
|
ddobbertin
Yak Posting Veteran
51 Posts |
 Posted - 2007-12-12 : 20:06:10
|
| I have a DTS package that is scheduled to run (through enterprise manager->Management->Jobs) 4 times a day. The job runs at the scheduled times however the package does actually run everytime. Looking at the Job history a successful run gives the following message:Executed as user: Administrator. ... DTSStep_DTSExecuteSQLTask_2 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_2 DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 1000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 1000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 2000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 2000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 3000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 3000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 4000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 4000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 5000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 5000 DTSRun OnProgress: DTSStep_DTSDataPumpTask_1; 6000 Rows have been transformed or copied.; PercentComplete = 0; ProgressCount = 6000 ... Process Exit Code 0. The step succeeded.The DTS that did not run gives only this:Executed as user: Administrator. DTSRun: Loading... DTSRun: Executing... DTSRun: Package execution complete. Process Exit Code 0. The step succeeded.So far I have not been able to see a trend, sometimes it does not run the first scheduled time of day, sometimes the second, some days all four run with no problems. Any and all help is appreciated!!! |
|
|
dataguru1971
Master Smack Fu Yak Hacker
1464 Posts |
Posted - 2007-12-12 : 20:08:18
|
It would probably depend on what the job is doing. Since the DTS job is reporting success, the problem is likely in the DTS package. What are the precedents...do the steps in the DTS only go to the next step on success? or simply on completion...is there a failure action within the DTS?It is clear, the job works, the DTS doesn't.
Poor planning on your part does not constitute an emergency on my part. |
 |
|
|
ddobbertin
Yak Posting Veteran
51 Posts |
Posted - 2007-12-12 : 20:32:31
|
| Well I went through the DTS package step by step and it worked perfectly. The steps were set to "on completion", which I changed to "on Success" to aid in debugging this problem. Any other ideas? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-12-12 : 23:24:59
|
| Enable package logging so you can see what happens. |
|
|
|
|
|
|
Job success but DTS did not run