Posting Yak Master
Posted - 10/17/2012 : 10:22:21
| I have Created Sql server job having 4 steps.
step 1 is Front End application disble mode
step 2 is ssis package
step 3 is ssis package
step 4 is enable Front end Appication
my Requirement is before Executing step 4 i need to Check the Status of step1,step2,step3 .if any one of the step is Failed ,
my 4step Shold not Execute.other wise my 4 step should Execute.
how to use Staus of previous step in jobs
if any body knows the logic pls Explain me.