What you have in the expression should work. But it's good to test it out. I see you have it scheduled to run every 2 minutes between 5 AM and 10 PM (EST). Is this what you want? If so, what type of job are you trying to run? FL or CDC job ?
Okay, as I mentioned earlier it's best to test this out. Before you schedule this job, I would recommend you set the scheduler to verbose. This way you can see the details in the Compose log for the scheduled job.
To set the verbose for the scheduler:
On the main Compose screen, click Management - Logs - Log Management. Scroll to the bottom and move the slide bar for Scheduler to Verbose, click OK to confirm, and click OK to save and close the Log Management screen.
Below is from my Compose log
"Compose.log"(11710,26):340 2022-04-19 16:56:33 [Scheduler ] [DEBUG] schedule 195 start time at 04/19/2022 20:56:33 +00:00 UTC "Compose.log"(11711,26):340 2022-04-19 16:56:33 [Scheduler ] [DEBUG] schedule 195 is cron policy, Quartz expression is '0 0/2 9-1 * * ?' "Compose.log"(11712,26):340 2022-04-19 16:56:33 [Scheduler ] [DEBUG] Job 195_Qjob has been scheduled "Compose.log"(11713,26):340 2022-04-19 16:56:33 [Scheduler ] [DEBUG] next time is 04/19/2022 20:58:00 UTC "Compose.log"(11714,26):340 2022-04-19 16:56:34 [Scheduler ] [DEBUG] next time is 04/19/2022 20:58:00 UTC
I have one more requirement where I need to run another compose wf on BD9 (business day 9) every month. We have a table where we keep tract of whether the day is BD or CD (Calendar day) if the day is BD9 then we should trigger the full load workflow at 10.30 PM. I don't think this is even possible using cron expression. Is there any way I can run the workflow based on the BD requirement? does this require any third party scheduling tool?