How to calculate the Local Schedule time from taskschedule.ScheduledLocalRunTime

Dieter Schmerlaib shared this question 2 years ago
Answered

Hi


I am trying to work out potential report and broadcast scheduling bottlenecks by writing a report on the yellowfin database. To do that I am using the taskschedule table. I need to understand what the column ScheduledLocalRunTime holds and how to calculate the time of the day as shown in the details of Schedule Management.


Thanks

Comments (1)

photo
1

Hi Dieter,

I've been playing around with this to find out the answer, and it looks like the ScheduledLocalRunTime shows how many seconds past midnight the broadcast is set to run at if the Frequency is not set as Minutes. For example, Daily at 1 AM would be 3600


I hope that makes sense.

David