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?
Happy new year, hope all is well over there. Just checking in to see if the SQL query I sent through previsouly was able to give you what you were looking for?
Happy new year.
Yes, that query worked OK for me.
This issue can be closed now.
Great, glad we could help. I'll close this off, but if you need anything else just let us know.
Comments have been locked on this page!