topic Re: How can I use cron to schedule for quarterly reports at certain intervals? in Alerting

How can I use cron to schedule for quarterly reports at certain intervals?

dmenon84 — Tue, 29 May 2018 15:19:00 GMT

Hi,

I want to schedule the report at following intervals

9/1 - 11/30
12/1 - 2/28(29) (this is an odd one because of leap years)
3/1 - 5/31
6/1 - 8/31

How can I do this using the cron schedule? Thanks in advance!

Thanks,
Deepthi

Re: How can I use cron to schedule for quarterly reports at certain intervals?

FrankVl — Tue, 29 May 2018 15:26:26 GMT

Is it OK to run the report at midnight of the first day of the next quarter? That would translate to 0 0 1 */3 *.

Then you just need to define the timerange for your report correctly, I guess earliest=-3mon@mon latest=@mon should do the trick?

Re: How can I use cron to schedule for quarterly reports at certain intervals?

somesoni2 — Tue, 29 May 2018 18:33:21 GMT

Assuming you want your quarterly report to run as following:

Quarter range     ###   Date on which Report should be run
9/1 - 11/30       ###  12/01 
12/1 - 2/28(29)   ###  03/01
(this is an odd one because of leap years)
3/1 - 5/31        ###   06/01
6/1 - 8/31        ###   09/01

Try the cron schedule as this (running every quarter, as above schedule, at 3 AM in the morning

0 3 1 3,6,9,12 *

Your search's time range would be -3mon@mon to @mon.
See the corresponding scheduled data here: https://crontab.guru/#0_3_1_3,6,9,12_* (click on next hyperlink to see more dates)