topic Re: Running a report on the third Monday of every month in Other Usage

How to set up a report to run on the third Monday of every month?

Rowank — Tue, 27 Jun 2023 14:53:36 GMT

Wanting to setup a Report to run on the third Monday of every month.
Is there a way to do this?
Any Cron Schedule I try doesn't allow me to commit the change.

Such as: 0 8 * * 1 [ "$(date +\%d -d 'today + 14 days')" -gt 14 ] && [ "$(date +\%u -d 'today + 14 days')" == 1 ] && echo "Run report"

Re: Running a report on the third Monday of every month

isoutamo — Tue, 27 Jun 2023 05:02:07 GMT

I think that this is working https://crontab.guru/#00_00_15-21_*_1

1 1 15-21 * 1

3rd Monday is between 15th and 21st day and last day field select it to run only Monday on those days.

r. Ismo

Re: Running a report on the third Monday of every month

Rowank — Tue, 27 Jun 2023 05:18:04 GMT

Thanks for the response.
I will let you know if it works next month!

Re: Running a report on the third Monday of every month

Rowank — Thu, 06 Jul 2023 01:18:53 GMT

Hi @isoutamo

Seems as though this cron schedule is running every Monday.
It ran last Monday and splunk is showing it will run next Monday.
Even though it should only be running the Monday after that.

Re: Running a report on the third Monday of every month

isoutamo — Thu, 06 Jul 2023 07:21:54 GMT

In some cron versions it needs that you will change 15-21 to 15,16,17,18,19,20,21.