SQL Extension 2.0: Cron Schedule Spanning Midnight

p_devulapalli — Tue, 25 Aug 2026 06:42:38 GMT

I'm configuring a SQL Extension and need to schedule data collection every hour from 5:00 PM to 8:00 AM daily.

I've tried using a Cron expression as of below but the extension keeps throwing an error "Schedule is not a valid quartz Cron expression"

0 17-23,0-8 * * ?

This does shows as valid when I verify using https://www.javainuse.com/cron

Just wondering if the extension supports combining ranges and lists in the same field (17-23,0-8) or do I need to create two different schedules to achieve this?

0 17-23 ? * *

0 0-8 ? * *

Any advice please?

topic SQL Extension 2.0: Cron Schedule Spanning Midnight in Extensions

SQL Extension 2.0: Cron Schedule Spanning Midnight