Trying to insert records to a MySQL table after job completes with tPostJob

Anonymous — Wed, 05 Jun 2019 10:30:58 GMT

Hello, what I want is to insert some records to a MySQL table after the completion of a specific job. I want to insert information like when job started, finished, how many rows where transfered etc.

I try to use tPostJob and connect it to tDBOutput to write my custom sql to insert the records but it seems that tDBOutput cannot be triggered by tPostJob.

Any help would be appreciated.

Thanks.

Re: Trying to insert records to a MySQL table after job completes with tPostJob

vapukov — Wed, 05 Jun 2019 13:18:25 GMT

Hi,

it could be called in tPostJob section:

but first - check for build in stats and logs framework

https://help.talend.com/reader/Ws0O43EFGSIwUF~lTgzv7g/xOyv1w03xytjgBbOlTKyeA

cheers, Vlad

topic Re: Trying to insert records to a MySQL table after job completes with tPostJob in Talend Studio

Trying to insert records to a MySQL table after job completes with tPostJob

Re: Trying to insert records to a MySQL table after job completes with tPostJob