Splunk Search

Why does my Cron for Sunday fail?

dlcrooks
Explorer

According to the docs for cron the Sunday code is 0.  

When I try to run this cron for the first Sunday of the month it displays Saturday!

00 12 1,2,3,4,5,6,7 * 0

Of course, when I use 6 for Saturday, it works!

00 12 1,2,3,4,5,6,7 * 6

What code am I supposed to use for Sunday?

TIA!

David

Labels (1)
Tags (2)
0 Karma

isoutamo
SplunkTrust
SplunkTrust

Interesting, also this https://crontab.guru/#00_12_1,2,3,4,5,6,7_*_0 shows that expression is correct and should run at 12:00 on 1st Sun on every month.

0 Karma

thall79
Communicator

When I click on the link for https://crontab.guru/#00_12_1,2,3,4,5,6,7_*_0  the next run date is at 2022-10-23 12:00:00 which is not the first Sunday Nov 6th 2022.  

I did some digging and found if you use the following: 00 12 1-7 * */7 (https://crontab.guru/#00_12_1-7_*_*/7) in crontab it appears to be what you are looking for.  

However when I attempt to use that cron in a Splunk schedule it does not work.  It appears that Splunk is not like the every 7th day trick */7.  

Reviewing Splunk documentation: https://docs.splunk.com/Documentation/Splunk/latest/Alert/CronExpressions

It appears the only values that can be used are 0-6.  Not sure if at this time if there is a way to run on the first Sunday of the month with cron in Splunk. 

travis

0 Karma

dlcrooks
Explorer

So, if the values are 0-6 then Sunday is 0 instead of 7...  I will have to play with it some more myself.

Thanks!

David L. Crooks

 

0 Karma

thall79
Communicator

I was thinking the same thing, but when I plugged in 0 instead of 7 Splunk gives me an error of invalid cron_schedule.  Now I did get 1 to work, but that was not helpful and seems the job will start on Nov 1st and then run everyday according to crontab.guru.  

travis

0 Karma

dlcrooks
Explorer

I think an issue is that the cron parser in Splunk is not the same as crontab.guru. I wish it was...

0 Karma

dlcrooks
Explorer

i am trying to schedule for this weekend and Splunk is not helping

0 Karma

gcusello
SplunkTrust
SplunkTrust

Hi @dlcrooks,

I don't know why this happens, I should have your data to check, but anyway, as a workaround, you could put a filter in your main search to be sure that your alert is executed only the first Monday in a month, something like this:

<your_search> date_mday<7 date_wday=sunday

Ciao.

Giuseppe

0 Karma

dlcrooks
Explorer

No, I tried the suggestion and I do not want to filter my data as I need the search scheduled.

0 Karma

dlcrooks
Explorer

My data has nothing to do with the cron string not working in Splunk. That is a bug in Splunk.

I will try out your suggestion. 

Thanks!

David

0 Karma

isoutamo
SplunkTrust
SplunkTrust
When you are expecting that this is a bug, please send bug report to Splunk Support!
Get Updates on the Splunk Community!

Database Performance Sidebar Panel Now on APM Database Query Performance & Service ...

We’ve streamlined the troubleshooting experience for database-related service issues by adding a database ...

IM Landing Page Filter - Now Available

We’ve added the capability for you to filter across the summary details on the main Infrastructure Monitoring ...

Dynamic Links from Alerts to IM Navigators - New in Observability Cloud

Splunk continues to improve the troubleshooting experience in Observability Cloud with this latest enhancement ...