I have 2 jobs scheduled to run at different times. I need to run the second job only if the first job was successful. Is there a way to achieve this in Matillion?

Matillion ETL
1

I have 2 jobs scheduled to run at different times. I need to run the second job only if the first job was successful. Is there a way to achieve this in Matillion?

2

Hello @jubith.kariyath​

Thanks for your post, there are several scheduling options as per our Manage Schedules documentation, check them out and let me know how you get on :)

Kind regards, Joe

3

Hello @JoeCommunityManager​

Thanks for the reply. I have already checked the documentation and could not find anything to support my requirement and hence I posted it here.

4

No worries,

 

There are two ways this can be achieved, You use the task history API endpoint at the start of the second orchestration and use the IF flow control to trigger the subsequent orchestration, that way you could schedule both the first pipe to run and the success message in task history to determine if the second executes.

 

An alternate way would be to just have them run one after the other in 1 unified orchestration job that was scheduled and use the output nodes of the former orch job to determine if the second needs to run.

 

I hope these help.

 

Kind regards, Joe