I have 2 jobs; Job2 is dependant on the completion of Step16 of Job1. All these steps are performing data refresh for different systems. Job1: has 25 steps in a sequenced manner i.e. Step 1 completes then Step2 starts and so on Job2: has only 1 Step, and later we plan to add more steps.
But for now, the problem is I cannot modify the sequence of Job1, and the time taken to complete the steps from Step16 to Step25 is huge. So I cannot add Job2 Step1 as Job1 Step26.
What I need is as my Job2 only care if Step16 of Job1 is complete. Is it possible to trigger Job2 when Job1 Step16 is completed?