Wednesday, March 7, 2012

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
>

No comments:

Post a Comment