How to make Flow execute multiple Scheduled Jobs in correct order?

[Aki18]

I created a custom Flow. The Flow calls custom Action that calls the Scheduled Job (A) to execute, using "

SncTriggerSynchronizer.executeNow()" method.

What I would like the Flow to do next is to call another Action to execute another Scheduled Job (B).

The important thing is to consider the sequence. Only after the first Scheduled Job (A) is completed, the next one (B) needs to work.

Please let me know how to achieve this.

*I tried to make the Flow check the "sys_trigger" record, but looks like its state is always "ready", so I think the Flow can't recognize the Scheduled job's completion.

Best Regards,

Aki

[Shivalika]

Hello @Aki18 

You can check the scheduled job completion in syslog_transaction table. In the URL field you need to give filter - CONTAINS - JOB Name. 

Even I had faced this issue and syslog_transaction came to my rescue as record will only be created here once the scheduled job is completely executed. 

Kindly mark my answer as helpful and accept solution if it helped you in anyway,

Regards,

Shivalika 

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwN

eEISQCY

[Aki18]

Hi @Shivalika ,

Thank you for your comment. The Scheduled Jobs run every 15 min, so the "syslog_transaction" table has multiple records for the same job. Is there any way for the Flow to recognize the exact record in "syslog_transaction" which has been called from the Flow?

[Shivalika]

Hello @Aki18 

You don't want to proceed with next run until this run is completed right ? 

Then it's simple you need to sort by created at or after field from z to a. There should be one record only. 

For eg - you are starting your flow at 10 and you are running the scheduled job at 10:05 - there will be only one record in this case. Please apply this practically and see, I have implemented this on my instance for 2 million records update by scheduled job and this works. 

You won't proceed with next run until this run is completed. 

Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will give me recognition for my efforts and also move this from unsolved to solved bucket. 

Regards,

Shivalika 

My LinkedIn - https://www.linkedin.com/in/shivalika-gupta-540346194

My youtube - https://youtube.com/playlist?list=PLsHuNzTdkE5Cn4PyS7HdV0Vg8JsfdgQlA&si=0WynLcOwN

eEISQCY

[Aki18]

Hi @Shivalika ,

Thank you for your reply, but I'm a little bit confused...

Let me clarify my requirements and your solution to them.

<My Requirements> *The Flow runs on a regular basis.

1) The Flow firstly calls custom Action that calls the Scheduled Job (A) to execute. 

2) The Flow needs to wait until the job (A) has been complete.

3) Only after the Scheduled Job (A) has been completed, the Flow should call another Scheduled Job (B) to execute. *The 2 jobs (A and B) are different.

<Your Solution>

- To confirm the completion of Scheduled Job (A), check "syslog_transaction" table by looking up the table in the Flow.
- By sorting the record, the Flow can reference the latest one record for the job.
 --> I'm wondering if this is not enough since the record might be older execution of the Job (A), because the current job execution may fail and the new log not created. I mean, is there a good way to identify exact syslog_transaction record that has been called by current Flow Action?