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?



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

Query Schedule in DB?

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


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.


Posts : 66
Points : 1873
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 Wed Jan 16, 2019 10:16 pm