topic Re: Single Job, Multiple Connections Switching in Talend Studio

Single Job, Multiple Connections Switching

MM1655984008 — Fri, 15 Nov 2024 22:45:44 GMT

Hi,

Does Talend Support swtiching between CONNECTIONS (different Schemas) to run a single Job.

Underlying Tables and its structure is same across all the Schemas/Connections

Say, i have Single Standalone Job STD_JOB, and have Connection_1, Connection_2 etc. So want to run this same job for each different connection dynamically

Thanks in advance

Re: Single Job, Multiple Connections Switching

gjeremy1617088143 — Thu, 07 Jul 2022 06:58:22 GMT

HI, you can list all the connection parameters in a flow use a tFlowToIterate to iterate on each connection then use a tRunJob with passing the parameters from father job.

https://help.talend.com/r/en-US/7.3/system/trunjob-tflowtoiterate-tfileinputdelimited-tjava-creating-parent-job-to-pass-value-to-child-job-standard-component-you-have

Send me love and kudos

Re: Single Job, Multiple Connections Switching

Anonymous — Fri, 08 Jul 2022 07:07:40 GMT

Sorry for my poor English. In my website, there is a coupon delivery activity. Now I create a new activity. If the start time is greater than the present time, the card will be issued automatically at the start time Now I want to implement the specific connection to the queue, and in the case where my default queue driver is sync, I want to use the redis driver to perform the above task. So I used onConnection and onQueue, but so far, it hasn't woked yet –

Re: Single Job, Multiple Connections Switching

Jwoodberry — Tue, 19 Jul 2022 11:24:19 GMT

Try this

$delay = Carbon::parse($memberCoupon->started_at)->diffInSeconds(Carbon::now());

$job = new GrantCoupon($memberCoupon);

$this->dispatch($job)->delay($delay)->onConnection('redis')->onQueue('coupons');

Your queue job will come into effect when dispatching, including the delay.