Is conditional execution possible for SQL Server Agent job steps?
That is if Step 1 returns 1 I want to go to Step 2.
If Step 1 returns 2 I want to go to Step 3.
If Step 1 returns 3 I want to go to Step 4.
It looks like it is not possible because the only distinction available for step completion is Success or Failure but I figured I would check with the experts here.
I know I can achieve this logic in SSIS package but was wondering if it can be done within SQL Server Agent.