Make the job status successful

sbhadra — Sat, 16 Nov 2024 02:12:03 GMT

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.

Re: Make the job status successful

Anonymous — Wed, 10 Jun 2020 04:05:23 GMT

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

topic Make the job status successful in Talend Studio

Make the job status successful

Re: Make the job status successful