Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I would like to trigger a subjob with two inclusive conditions:
The main subjob extracts source data using
tDBInput_1, and flows into 1 of 2 outputs - an UPSERT or a DELETE.
I have a 2nd subjob that increments the change version. But I only want to increment the change version if tDBInput_1 has more than 0 rows, and also if the UPSERT and DELETE outputs do not fail.
Please see attached image.
Any ideas? TIA!
From the little I understood, you may take the 'on subjob ok' to a step prior / backwards. As I don't see your entire flow, this is just my 2 cents
The rest of the flow is irrelevant. What I need is for the "Increment Change Version" to execute only if both conditions are true within the subjob that is shown in the pic:
Using 'On Subjob OK' will trigger the "Increment Change Version" even if there are no rows. And using an 'Run If' will trigger the "Increment Change Version" even if tMap, Upsert, or Delete fail on an error.
a tJavaFlex may help.
CT_dbo_Task -->OnSubJobOk --> tJavaFlex --> RunIf (your Condition ) --> Increment Change Version
Best Practice also 🙂