KAPOW

Would you like to react to this message? Create an account in a few clicks or log in to continue.
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.


2 posters

    Query Schedule in DB?

    bharr
    avatar
    bharr


    Posts : 2
    Points : 2076
    Join date : 2018-08-27
    • Post n°1

    Query Schedule in DB? Empty Query Schedule in DB?

    Post by bharr 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
    • Back to top
    jking
    jking
    jking


    Posts : 103
    Points : 3851
    Join date : 2014-03-01
    Location : USA
    • Post n°2

    Query Schedule in DB? Empty Re: Query Schedule in DB?

    Post by jking 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
    • Back to top
      Current date/time is Sat Apr 27, 2024 1:25 pm