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 |
|
mdelgado
Posting Yak Master
141 Posts |
 Posted - 2002-04-03 : 09:13:14
|
| Hello all.Since I designed this DTS package a few months ago, I've been having trouble getting it to run when scheduled. This package is very simple; it imports a text file and runs xp_sendmail to email the officers at my company shipped sales data for the current week.At first, I would notice the the sqlagent would unexpectedly stop running. So I would start the agent back up, manually execute the package and all would be fine. Other times the package wouldn't run at all, so I would have to restart the server in order to get it to run. Right now, I'm calling the dts package from a batch file and using a third party program to execute the batch file every morning and this seems to be working a lot better since I don't have to rely on the sqlagent service to be running.Question, how can I avoid the sqlagent service to continually stop unexpectedly??thanks |
|
|
Jay99
468 Posts |
|
|
mdelgado
Posting Yak Master
141 Posts |
Posted - 2002-04-03 : 09:47:18
|
| Nope. This package was designed after adding the service packs. |
 |
|
|
|
|
|
dts package doesn't run when scheduled