Friday, March 23, 2012

Scheduling

Hi
when scheduling SQL server DTS packages, i know we can set up a chain of
steps saying(let's say) execute step2 on success of step1. But can we specify
multiple chaining...meaning to say that execute step3 on success of both
step1 and step2.
Any help would be appreciated.
Thanks
Neeraj
The default behavior of a SQL Agent job step is to quit the job when an
error occurs. Consequently, step 3 will execute only if both steps 1 and 2
succeed.
Hope this helps.
Dan Guzman
SQL Server MVP
"ReportFAQGuy" <ReportFAQGuy@.discussions.microsoft.com> wrote in message
news:335C71C0-D023-4C11-B99A-907CAC6DE965@.microsoft.com...
> Hi
> when scheduling SQL server DTS packages, i know we can set up a chain of
> steps saying(let's say) execute step2 on success of step1. But can we
> specify
> multiple chaining...meaning to say that execute step3 on success of both
> step1 and step2.
> Any help would be appreciated.
> Thanks
> Neeraj

No comments:

Post a Comment