Execute stored proc when two separate subjobs succeed

Anonymous — Wed, 01 Aug 2018 04:02:45 GMT

I'm new to Talend.

I am replicating two database tables from the source to two local staging tables. Each process is in its own independent subjob and multi-thread is turned on.

When both subjobs complete successfully, I want to execute a stored procedure, but don't know how to determine that both subjobs completed successfully.

I've tried on subjob ok, linked to the proc connector, but only one subjob will link.

I've tried on subjob complete, but the proc will execute when only one subjob completes.

I looked into the tPostJob connector, but it sounds like it will execute even if one or both subjobs fail.

Any thoughts?

Thanks!

Re: Execute stored proc when two separate subjobs succeed

Anonymous — Mon, 06 Aug 2018 07:51:51 GMT

Hello,

You need for this use case two jobs. The parent job is your mentioned jobs for the start and the second job contains the two subjobs.

Parent job:tRunJob-->onsubjobok-->stored procedure

Child job: subjob1

subjob2

Let us know if it is OK with you.

Best regards

Sabrina

topic Execute stored proc when two separate subjobs succeed in Talend Studio

Execute stored proc when two separate subjobs succeed

Re: Execute stored proc when two separate subjobs succeed