Loading

Conditional Running of a Step in SQL Server Job

Soumya Rani

5y905

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?

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Mario Scheeren5y ago
https://docs.microsoft.com/en-us/sql/t-sql/language-elements/if-else-transact-sql?view=sql-server-ver15

https://docs.microsoft.com/en-us/sql/t-sql/language-elements/case-transact-sql?view=sql-server-ver15
+2