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 - 2001-03-18 : 18:53:53
|
John writes "I've got a fairly straight foward DTS package that executes a stored procedure then takes the resulting records and transforms them into a fixed field text file.
I have taken this DTS package and scheduled it to run every hour at 10 past the hour. The package will run fine for several days. Then at what appear to be random times the package will never stop running, or as far as SQL Server Agent is concerned the job is still running. The text output file is never written and of course the next scheduled running times never happen.
When I stop the job the text file is created and everything continues like it is suppose to.
The normal run time is about 5 seconds.
Any ideas what might be causing this to happen?
NT 4.0
SLQ 7.0 no SP installed" |
|
|
|
|
|
DTS Scheduled process in SQL 7 not finishing