I want to create a job with following steps:
- get records qty for table A
- if A.qty > 1000 then execute Task1(A)
- if A.qty <= 1000 then execute Task2(A)
- some other step
- some other other step
- get records qty for table B
- if B.qty > 1000 then execute Task1(B)
- if B.qty <= 1000 then execute Task2(B)
- some other step
- get records qty for table C
- if C.qty > 1000 then execute Task1(C)
- if C.qty <= 1000 then execute Task2(C)
I know how to make conditions, but I need to duplicate 3 steps for each variable value. Is it possible to create 1 set of tasks, or group them somehow and then just change the value of variable?