Hi
I want Job A to run as soon as possible (doesn't have to be immediate - 5-15 min is fine) after the completion of the Oracle SP |
If you want Job A to run as soon as possible, you can use a tInfiniteLoop component to check if Job A has already executed or not every 5-15 mins, if Job A has executed one time today, use a tDie to exit the loop.
myMain job:
tInfiniteloop
|
iterate
|
tFileInputDelimited--main--tJavaRow_1--runIf_1-->tOracleInput--main--tJavaRow_2---runIf_2--tRunJob
--runIf_3-->tDie
Set the condition of runIf_3 as:
(Boolean)globalMap.get("AhasExecuted")
Schedule the myMain job to run at a specified time of each day (for example, 8 o'clock per day), once myMain job starts to run, it will loop to check if Job A has already executed or not every 5-15 mins.
Shong