[resolved] After Job Update SQL In Talend Jobs

[Anonymous]

Hi Gurus,
I have a Talend job that loads into a Oracle Table 'XYZ'. Once the job completes loading, I want to run a small update SQL on the same XYZ table. 
I do not want to create a Store Procedure for this small update SQL. So is there anyway we can run SQL's in the same job as a after job trigger? 
Thanks in advance,
Raj

[Anonymous]

Hi Raj,
You can use txxxRow component with OnSubJobOk link from your job, this should do the work... Use whatever update query you have inside this txxxRow component.
Vaibhav

[Anonymous · Accepted solution]

Thank you, tOracleRow worked for me. Appreciate your help.