Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
Below is my job. Currently, the query which I am running if it does not return any rows I am terminating the job, because I don't want to send any email if there are no rows. Hence, I thought of to terminate the job using the tDie component with a message. However, since I am terminating the job the status of the job is recorded as failed. Please suggest any possible way to make the job successful and also not to send any email.
Hi
Use runIf connector to trigger next business processing based on the query result, for example:
tOracleinput--main--tHashOutput
--runIf1---tWarn
--runIf2--tHashInput--main-tUniqRo-tFlowToIterate...
--onsubjobok--tJava(Email body)...
set the condition of runIf1 as:
((Integer)globalMap.get("tDBInput_1_NB_LINE"))==0
set the condition of runIf2 as:
((Integer)globalMap.get("tDBInput_1_NB_LINE"))>0
the subjobs linked by runIf2 will not be executed if there is no rows returned,
Use a tWarn to send out a customize message.
Regards
Shong