I'd like to provide a list of reports and what their schedule frequency and next run time is. I see there are some T_AV_REPORT tables, but nothing that shows if it's weekly, daily and so on. Any suggestions?
The column schedule_task_id can be used to find the appropriate schedule information in the t_scheduled_tasks table. The rule has the frequency details. It is an internal format not really meant for reporting and is subject to change
Sean has mentioned a useful table but putting the contents into an easy-to-use report like Philip asked for is going to take quite a bit of slice and dice work.
Here's a SQL to get the raw data:
select tar.REPORT_NAME , tar.SCHEDULE_TASK_ID, tst.rule from t_av_reports tar join t_scheduled_tasks tst on tst.id = tar.schedule_task_idwhere tar.SCHEDULE_TASK_ID > 0order by 1
That column called RULE, it contains values that are variations on the following format:
"<com.aveksa.common.scheduler.rules.CronRule> <ruleStartDate>2017-06-18 23:00:00.0 UTC</ruleStartDate> <year>*</year> <month>*</month> <dayOfMonth>-</dayOfMonth> <dayOfWeek>1</dayOfWeek> <hour>18</hour> <minute>0</minute> <once>false</once></com.aveksa.common.scheduler.rules.CronRule>"
Retrieving data ...