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 - 2002-07-19 : 08:13:08
|
| flori writes "Hi there,Please, can you help me with this problem?I'm new in this SQL Server "problems" (I'm a VB programmer and because the DBA just left the company , I have to take care of sql.).I just got this situation today:-I have a job , who's calling a DTS Package, using a shell command.The problem is that I found this morning this job in executing status.I tried to stop the job ('sp_stop_job').The result was that the "job was succesfuly stoped " which is not for real, because if I run the 'sp_help_job' for this specific one it showing me that the status is 1 (Executing).I tried from Entreprise Manager-Nothing happend.No error, no nothing.The only problem is that the job it doesn't stop!.Thank YouFlori" |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2002-07-19 : 08:41:00
|
sp_stop_job will send a flag telling the job to stop, it will not physically stop it. The job will be trying to rollback any transactions and may get stuck, the only thing you may be able to do(when you've had enough!! ) is to restart the SQL Service Services...PeaceRick |
 |
|
|
|
|
|
Job problem