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:
>

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:
>

Job Agent Step

Hi all,
I created a job in SQL Agent with 1 step which includes 2 step, e.g.
sp_start_job 'step1' and sp_start_job 'step2'. step1 and step2 are 2 agent
jobs. How can I continue the step2 while the 1st sp_start_job 'step1' is
failed?
Thanks in advanceYou need to make two job steps, one for each sp_start_job command. Then have
the first step "Go to Step 2 on failure" from the advanced tab.
Andrew J. Kelly SQL MVP
"stephanie" <stephanie@.discussions.microsoft.com> wrote in message
news:E980E9A0-5DDD-4A4B-B11D-0F5D76B7C375@.microsoft.com...
> Hi all,
> I created a job in SQL Agent with 1 step which includes 2 step, e.g.
> sp_start_job 'step1' and sp_start_job 'step2'. step1 and step2 are 2
> agent
> jobs. How can I continue the step2 while the 1st sp_start_job 'step1' is
> failed?
> Thanks in advance
>|||Hi,
Create step-2 for the same job. Now double click on the
Step -1 , go to advanced tab. In that from the "failure action " list box
select go to next step.
Thanks
Hari
SQL Server MVP
"stephanie" <stephanie@.discussions.microsoft.com> wrote in message
news:E980E9A0-5DDD-4A4B-B11D-0F5D76B7C375@.microsoft.com...
> Hi all,
> I created a job in SQL Agent with 1 step which includes 2 step, e.g.
> sp_start_job 'step1' and sp_start_job 'step2'. step1 and step2 are 2
> agent
> jobs. How can I continue the step2 while the 1st sp_start_job 'step1' is
> failed?
> Thanks in advance
>

Job Agent Step

Hi all,
I created a job in SQL Agent with 1 step which includes 2 step, e.g.
sp_start_job 'step1' and sp_start_job 'step2'. step1 and step2 are 2 agent
jobs. How can I continue the step2 while the 1st sp_start_job 'step1' is
failed?
Thanks in advanceYou need to make two job steps, one for each sp_start_job command. Then have
the first step "Go to Step 2 on failure" from the advanced tab.
--
Andrew J. Kelly SQL MVP
"stephanie" <stephanie@.discussions.microsoft.com> wrote in message
news:E980E9A0-5DDD-4A4B-B11D-0F5D76B7C375@.microsoft.com...
> Hi all,
> I created a job in SQL Agent with 1 step which includes 2 step, e.g.
> sp_start_job 'step1' and sp_start_job 'step2'. step1 and step2 are 2
> agent
> jobs. How can I continue the step2 while the 1st sp_start_job 'step1' is
> failed?
> Thanks in advance
>|||Hi,
Create step-2 for the same job. Now double click on the
Step -1 , go to advanced tab. In that from the "failure action " list box
select go to next step.
Thanks
Hari
SQL Server MVP
"stephanie" <stephanie@.discussions.microsoft.com> wrote in message
news:E980E9A0-5DDD-4A4B-B11D-0F5D76B7C375@.microsoft.com...
> Hi all,
> I created a job in SQL Agent with 1 step which includes 2 step, e.g.
> sp_start_job 'step1' and sp_start_job 'step2'. step1 and step2 are 2
> agent
> jobs. How can I continue the step2 while the 1st sp_start_job 'step1' is
> failed?
> Thanks in advance
>