/build/static/layout/Breadcrumb_cap_w.png

Is there a way to schedule a KACE SMA report to run on the last day of the month?

Would like to run a scheduled report on the LAST day of the month regardless of how many days are in the month .


0 Comments   [ + ] Show comments

Answers (3)

Answer Summary:
Posted by: Nico_K 2 months ago
Red Belt
1

the schedule is made over a cronjob.
Sadly cron cannot run this like that without additions.
As soon as you can add a SQL statement to that (like you want to run a script on the last day of the month) it is possible, but for scheduling reports this is not possible.

Posted by: akmagnum 2 months ago
Red Belt
0
Sadly no. You will have to settle for the 30th of every month.

Comments:
  • ... except for february which usually (at least none during my lifetime ^^) does not have a 30th. - Nico_K 2 months ago
    • very true. forgot about february - akmagnum 1 month ago
Posted by: Hobbsy 1 month ago
Red Belt
0

Top Answer

po0naQQzstZvLLSEXQdforrnyH8BBKpwP2i9VK9qXkASwbPVz1tBW4mkYyArw4UyJpTnYIof8DX41AZM6HENoAAAAASUVORK5CYII=

I think you can do this, but you have to create multiple schedules and use custom schedules on each.

For example (again I think) the following schedule will run only on the months when the last day is the 31st

0 10 31 1,3,5,7,8,10,12 *

Whereas if the last day is the 30th you would need

0 10 30 4,6,9,11 *

Which just leaves the constant challenge of February and a leap year, so just suck it up and run it on the 29th 

0 10 28 2 *

So duplicate your report twice, as you can only have a single schedule per report, then add one each of the schedules to each of the reports.

Multiple scheduled reports, but only one report a month on the last day of that month!!

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ