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
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.
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
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?
The same question
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
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
Hi Shahul,
Just checking in to see if this SQL query was able to give you what you were looking for?
Cheers,
Neal
Hi Shahul,
Just checking in to see if this SQL query was able to give you what you were looking for?
Cheers,
Neal
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
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
Replies have been locked on this page!