Table or View for Report Schedule

[PhilipMartinez2]

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?   

[SeanMiller1 · Accepted solution]

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

[EdwardBertsch2]

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_id
where tar.SCHEDULE_TASK_ID > 0
order 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>"