Make the job status successful

[sbhadra]

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.

[Anonymous]

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