Can you please provide the query to see broadcast times of various reports?

shahul samad shared this question 21 days ago
Awaiting Reply

Comments (2)

photo
1

Hi Shahul,


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.


Cheers,

Neal

photo
1

Hi Shahul,


Just checking in to see if this SQL query was able to give you what you were looking for?


Cheers,

Neal