I have a job(Main_Job) which calls other jobs(like Job_1, Job_2, Job_3) by using Tsystem component jobs sequentially.
Here my requirement is, if the Job_1 fails i want to capture it in Main_job and kill the remaining jobs which are in the queue.
Can anyone please help me how to capture the error into a context or table.
Thanks in advance.
Hi @shong ,
As you can in the Caprure1, Before calling the job from Tsystem component, am inserting the job name as "R" in JOBMASTER & JOBEXECUTION, on the called job is completed am updating "R" as "C" and if the job fails i want to update as "F" which am doing as seen in the Capture2.
Hi @shong ,
Suppose am calling 4 jobs using TSystem, in 3rd job i got error like "Table or view doesn't exist".
I can see this error on console.
Here my requirement is to kill the job when an error occurs, instead of calling the next job, which is not happening now.
Please help me how to catch errors coming from TSystem component and kill other jobs in sequence.
Hi @ShaX ,
By default tSystem Error is passed through Console.
In the basic settings of tSystem chose Standard Output and Error Output to "to Global variable" and call the Global variable in tJava to get the error output.
In addition you can also use the Exit Value Global variable for tSystem in the run if condition to pass the control to your sub Jobs.
Thanks and Regards,
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Read about some useful Context Variable ideas