[resolved] After Job Update SQL In Talend Jobs

Five Stars

[resolved] After Job Update SQL In Talend Jobs

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

Accepted Solutions
Five Stars

Re: [resolved] After Job Update SQL In Talend Jobs

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

All Replies
Four Stars

Re: [resolved] After Job Update SQL In Talend Jobs

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
Five Stars

Re: [resolved] After Job Update SQL In Talend Jobs

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