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 |
|
dbashland
Starting Member
1 Post |
 Posted - 2005-07-15 : 13:56:15
|
| I have a job that executes a DTS package.The package runs successfully, but the status of the job that started it says 'Executing step 1...' forever. Other similar jobs run ok. It seems the job isn't getting notified that the DTS package completed. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-07-15 : 13:59:29
|
| Try recreating the job. How was the job created? Via the DTS scheduler wizard? If so, you may want to try creating your own job manually and calling dtsrun.exe. Also, try running the DTS package via dtsrun.exe from a cmd window on the database server. Log into the database server using the MSSQLSERVER service account when you do this to simulate what the job is doing.Tara |
 |
|
|
|
|
|
DTS job status stuck