I have a job TestSau in SQL Server. There are three steps :
Step1 Step2 Step3
Now I have to check for a data condition, whose ONLY outcome can be case1 or Case2 I need to perform this check-in step1. If Case 1 is true I should go to Step3 and if Case 2 is true I should go to Step 2.
How can I achieve this?