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 |
|
lee_h
Starting Member
36 Posts |
 Posted - 2003-03-12 : 18:02:38
|
| I have a Job that is scheduled to run a DTS package at 6am every morning.It takes about 8 mins to complete, but the job is still running when I get in, if I don't cancel it, it won't run the following morning (particularly important when there is no one in on Sat/Sun to stop it).I've checked the log and it says that all steps have been sucessfully completed. I've also checked the current activity and there is nothing still connected to the server.Anyone have any suggestions?Lee |
|
|
jasper_smith
SQL Server MVP & SQLTeam MVY
846 Posts |
Posted - 2003-03-12 : 18:15:32
|
| Does the job complete if you run it manually ?Does the job try and send any notifications i.e. mail ?HTHJasper Smith0x73656c6563742027546f6f206d7563682074696d65206f6e20796f75722068616e6473203f27Edited by - jasper_smith on 03/12/2003 18:20:10 |
 |
|
|
chadmat
The Chadinator
1974 Posts |
|
|
lee_h
Starting Member
36 Posts |
Posted - 2003-03-12 : 18:21:28
|
| Yes, the job completes if started manually.There are success and failure e-mails.The success e-mails get sent and the log says that the failure e-mails havn't been executed (which is what I expect) |
|
|
|
lee_h
Starting Member
36 Posts |
Posted - 2003-03-12 : 18:23:07
|
| We are already on SP2, but I'll give the work around a go |
|
|
|
lee_h
Starting Member
36 Posts |
Posted - 2003-03-13 : 18:00:57
|
| Just to give you an update. The work around seems to have worked. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-03-13 : 18:03:37
|
| Well that's good. I wonder if service pack 3 would have worked instead of the work around.Tara |
|
|
|
|
|
|
Job not quiting