Running SQL server agent job steps based on condition
Posted on 2012-08-15
I have a created a sql server job with two steps. I need to run step one based on a condition. If the condition doesn't staisfy run another step. (each step conatins an ssis package to run)
To implement this, I have created another step in the job which runs first with the condition.
if the condition staisfies -set on success- go to step one. if the condition fails -raiseerror-set on failure- go to step2
Is there any other way to do this other than using onsucess and onfailue? If the condition does not satisfy, I do not want to use raiseerror. It should just execute step 2