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

shahul samad shared this question 3 months ago
Answered

Comments (3)

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

photo
1

Hi Shahul,


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?


Cheers,

Neal

photo
1

Hi Neal,

Happy new year.

Yes, that query worked OK for me.

This issue can be closed now.


Cheers

Shahul

photo
1

Hi Shahul,


Great, glad we could help. I'll close this off, but if you need anything else just let us know.


Cheers,

Neal

photo