To list out all active broadcasts and their schedules, please use the following query:
SELECT * FROM TaskSchedule WHERE ScheduleUnitCode = 'BROADCASTID' and ScheduleIsOn = 1
Note that the FrequencyType will tell you if it runs daily, minutes, etc. FrequencyUnit will break this down further (eg 60 for every hour) and the ScheduledLocalRunTime will be how many seconds past midnight the report is run (if it is not hourly or every 15mins or similar).
If you need any more information on this, just let me know.
Just checking in to see if this SQL query was able to give you what you were looking for?
Comments have been locked on this page!