Details about taskschedule Table

Durgesh Mange shared this question 2 months ago
Answered

Hello Team,

We have created one report in smart reporting. which is dependant on Taskschedule table and helps to provide status of last broadcast.


This Table contains column called "TaskSchedule"."LastRunTime",

"TaskSchedule"."ScheduledLocalRunTime".


can you please explain the what values these column hold. is it actual runtime of schedule broadcast? are these values in seconds?


Awaiting your response.


Regards,

Durgesh

Comments (2)

photo
1

Hi Durgesh,

Thanks for reaching out with this question.

I believe the LastRunTime is logging in seconds as is the ScheduledLocalRunTime however I have been unable to verify.

I will continue to investigate these columns and update you as soon as I find out.

Thanks,

Jared

photo
1

Hi Durgesh,

Ok so the LastRunTime shows how many seconds after midnight the schedule ran (based on GMT+0).

The ScheduledLocatRunTime shows how many seconds after midnight it is sheduled to run (again based on GMT+0).


For more details on the Task Scheduler and table, see the following article: The Yellowfin Task Scheduler.


Please let us know if you have any other questions.


Regards,

David