How to calculate the Local Schedule time from taskschedule.ScheduledLocalRunTime

Dieter Schmerlaib shared this question 2 years ago


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.


Comments (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.