Hi,
I have some Matillion scheduled job, (For example there are two separate Matillion job one scheduled at 5.00pst another one at 5.30pst) in that if 5.00pst got failed 5.30pst will run and have data error, I am facing this problem for long time. So, to overcome this problem is there any automation way to stop or pause the schedule of the dependent job for few minutes or until the issue of main job get fixed. The main moto is if any main job got failed its dependent job also need to pause. If any solution to this kindly answer below
Thank you
Hari Ram K
Hello @HariRamK
I spoke with the team who suggested triggering it via SQS. Make the last component in the 5.00 run a "SQS message component" with a 'green connection' to it, and send the message that triggers the other job. As well as not running if the previous job fails and not having to line up the times precisely, that has some scalability benefits too. If you must do it by checking, the Matillion API query profile is installed by default - you can query the run history, filter it using our normal tools to get the last run of a named job and test whether it's successful. You could then end job execution immediately on the 5.30 job if the 5.00 failed.
Kind regards, Joe
Ok @JoeCommunityManager will try this I will get back to you.