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 .
Answers (3)
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.
Top Answer
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!!
