Job Hangs...

I've seen several posts concerning Jobs Hanging with "Executing Step
1..." whatever .. I have a job that will sometimes do that as well.
It's a small data mining type thing that runs a couple of times a day
- and missing a run is not a problem. BUT - when it hangs, it won't
run again until someone stops it.
Therefore - can someone tell me how to issue a command to stop/cancel
a job? I can just schedule that job 10 minutes before the one that
hangs... then just hope the "Stop the Hanging Job" job doesn't
hang...You could try running sp_stop_job. If this isn't relevant for your type of
process, you could use sp_who2 to see what the process is doing and use KILL
on the relevant SPID.
HTH,
Paul Ibison|||Kill <SPID> is your safest bet to stop it.
On Apr 23, 9:12 am, Ray <ray_p...@.bellsouth.net> wrote:
> I've seen several posts concerning Jobs Hanging with "Executing Step
> 1..." whatever .. I have a job that will sometimes do that as well.
> It's a small data mining type thing that runs a couple of times a day
> - and missing a run is not a problem. BUT - when it hangs, it won't
> run again until someone stops it.
> Therefore - can someone tell me how to issue a command to stop/cancel
> a job? I can just schedule that job 10 minutes before the one that
> hangs... then just hope the "Stop the Hanging Job" job doesn't
> hang...|||Thank you very much...!!!
On 23 Apr 2007 10:09:10 -0700, tmorris <TheRealPawn@.gmail.com> wrote:
>Kill <SPID> is your safest bet to stop it.
>On Apr 23, 9:12 am, Ray <ray_p...@.bellsouth.net> wrote:
>> I've seen several posts concerning Jobs Hanging with "Executing Step
>> 1..." whatever .. I have a job that will sometimes do that as well.
>> It's a small data mining type thing that runs a couple of times a day
>> - and missing a run is not a problem. BUT - when it hangs, it won't
>> run again until someone stops it.
>> Therefore - can someone tell me how to issue a command to stop/cancel
>> a job? I can just schedule that job 10 minutes before the one that
>> hangs... then just hope the "Stop the Hanging Job" job doesn't
>> hang...
>