KAPOW

Welcome to the Kapow forum. Here you can get help, use your skills to help others and enjoy hanging out in the company of other Kapow Robot Developers.


Query Schedule in DB?

Share

bharr

Posts : 1
Points : 28
Join date : 2018-08-27

Query Schedule in DB?

Post by bharr on Mon Aug 27, 2018 7:51 pm

Hello,

Has anyone ever queried the robot schedule in the DB using KapowLogs? I cannot figure out how to find out when the robot is scheduled to run next using SQL queries.

Thanks
avatar
jking

Posts : 48
Points : 1730
Join date : 2014-03-01
Location : USA

Re: Query Schedule in DB?

Post by jking on Fri Aug 31, 2018 12:00 am

You can query SCHEDULE_RUN for TRIGGERTIME.  Using the historical data in the log you can determine the interal between runs and calculate the next TRIGGERTIME

    Current date/time is Sat Sep 22, 2018 3:30 am