topic Re: How to trigger a scheduled report for every Sunday AND every first day of the month? in All Apps and Add-ons

How to trigger a scheduled report for every Sunday AND every first day of the month?

Chamrong — Thu, 02 Mar 2017 17:45:09 GMT

I am using Splunk DB Connect v2. I would like to write cron job to run every Sunday AND every first day of the month.

The job is running on every Sunday (whatever day of the month)
the job is running every 1st day of the month (any day of the week)

Re: How to trigger a scheduled report for every Sunday AND every first day of the month?

cmerriman — Thu, 02 Mar 2017 18:17:31 GMT

maybe something like this:

10 8 *,1 * 1,*

where 10 is the minute and 8 is the hour of the day.

Re: How to trigger a scheduled report for every Sunday AND every first day of the month?

Chamrong — Thu, 02 Mar 2017 18:43:41 GMT

dbconnect do not recognise and provide error : Enter seconds or a valid cron string

Re: How to trigger a scheduled report for every Sunday AND every first day of the month?

cmerriman — Thu, 02 Mar 2017 18:49:24 GMT

hmm, I tested the cron string in 'report' and it worked. i'll noodle a bit more.

Re: How to trigger a scheduled report for every Sunday AND every first day of the month?

Chamrong — Thu, 02 Mar 2017 18:51:03 GMT

I am using dbconnect2

Re: How to trigger a scheduled report for every Sunday AND every first day of the month?

cmerriman — Thu, 02 Mar 2017 19:02:02 GMT

I have DBConnect V3 and that cron didn't error out, so I'm not sure if something changed from V2 to V3. I'm not sure if that cron will work exactly as you want, but I think it would do the job, but if you can't get it to work in V2, it's moot anyways 😞

Re: How to trigger a scheduled report for every Sunday AND every first day of the month?

cpetterborg — Thu, 02 Mar 2017 19:31:37 GMT

According to CrontabGuru, you will want to use:

10 8 1 * 0

Re: How to trigger a scheduled report for every Sunday AND every first day of the month?

Deepz2612 — Mon, 23 Oct 2017 02:46:59 GMT

I wanted to run a report on every first Business day of the month.
i.e., If the first business day of the month falls on Monday-Friday I want the report to run
and if it falls on Saturday/sunday I want the report to report on the next business day.

Re: How to trigger a scheduled report for every Sunday AND every first day of the month?

cpetterborg — Mon, 23 Oct 2017 12:18:12 GMT

There is no cron scheduling ability to perform that particular schedule. If it had some kind of optional functionality, it could be possible, but that level of complexity is not available.

Re: How to trigger a scheduled report for every Sunday AND every first day of the month?

Deepz2612 — Mon, 23 Oct 2017 15:07:47 GMT

Thanks for your reply

Re: How to trigger a scheduled report for every Sunday AND every first day of the month?

Deepz2612 — Tue, 29 Sep 2020 16:23:48 GMT

Hello,
I have onboarded the database data in db connect and while setting up the report the column with timestamp are not of desired format.
Can you help me with some ideas on how to get the output in desired format..
for eg.for the column Sys_entry_timestamp has the value 09-10-2017 00:09:45:6000 AM but i need it as 10 Sep 2017 00:09:45 AM.