topic Re: Cron job condition when running DBX query in Splunk Dev

Cron job condition when running DBX query

k_harini — Sat, 03 Jun 2017 16:56:58 GMT

Hi,
I have a condition where we have to run dbxquery command based on scheduling condition.. Only on Mondays between 8 am to 2 pm.. Incase if Monday is public holiday it should run on Tuesday.. How can we achieve this?

Re: Cron job condition when running DBX query

woodcock — Sat, 03 Jun 2017 17:28:37 GMT

Run the Monday one with a regular cron then every year go through and figure out when the holiday things are and setup INDIVIDUAL jobs for each Tuesday, writing the queries in such a way that the Tuesday run always overwrites the previous day's run.

Re: Cron job condition when running DBX query

k_harini — Sun, 04 Jun 2017 01:49:30 GMT

How to make Tuesday run overwrite? Here we have used saved search with dbxquery and summary indexed the data.. I can have a look up list of public holidays. With tat how can I change cron job?

Re: Cron job condition when running DBX query

woodcock — Sun, 04 Jun 2017 03:54:06 GMT

Keep the same search that should end in | collectand add to it something like this:

| search ThisFieldDoesNotExist="So this will throw away all the events we just saved"
| append [ search [|makeresults | eval search = "earliest=-1d@d latest=0d@d-1" | table search] index="YourSummaryIndexHere"
|delete ]