Cron Expression: Every 15 Minutes, Between 07:30-17:15 Daily

Please help me in Orchestrator schedule to run every 15 minutes between 7:30AM to 17.15PM.

Hello did you find a resolution for this? I have a similar request.
thank you.

You probably need three triggers

0 0,15,30,45 9-16 ? * * * (At 0, 15, 30, and 45 minutes past the hour, between 09:00 AM and 04:59 PM)

AND

0 30/15 8 ? * * * (Every 15 minutes, starting at 30 minutes past the hour, between 08:00 AM and 08:59 AM)

AND

0 0,15 17 ? * * * (At 0 and 15 minutes past the hour, at 05:00 PM)

Please let me know if it works for you :slight_smile:

Thank you! Yes, I did split into three expressions and this will work. :+1:

Hi @JAS_CFB,

There are similar asks with solutions already in the forum with a quick search. You can also narrow your search by Tags such as Cron and Trigger or look at those tags specifically.

Have a look at these solutions to get an idea

As @ReneSchue shows there are different ways to tackle the same problem (e.g. listing out the minutes vs a range, or occurrence). However, using the original Topic as an example Every 15 Minutes, Between 07:30-17:15 Daily it is quite right as 07:30 to 08:30 is missing

  1. First we need to take care of the 07:30, 07:45
    0 30/15 7 ? * * == Every 15 minutes, starting at 30 minutes past the hour, between 07:00 AM and 07:59 AM

  2. Then we look after the whole hours 08:00 to 16:45
    0 */15 8-16 ? * * == Every 15 minutes, between 08:00 AM and 04:59 PM

  3. And finally the last 2 runs at 17:00 and 17:15
    0 0-15/15 17 ? * * == Every 15 minutes, minutes 0 through 15 past the hour, between 05:00 PM and 05:59 PM

Have a look at the other linked topics and other Cron Posts, many of them source referenced that will help you to learn/understand Cron Expression along with links to Cron Expression Generators that many find helpful.

2 Likes

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.