Job Schedules - next run time

Help
1

How to get the next run time of each BOTs using sql query from the UiPath database.
I can get the CRON expression from the [ProcessSchedules] table.

Any help appreciated.

2

You can use the Orchestrator API to get the scheduled jobs and there you have the StartProcessNextOccurrence property which is exactly what you are looking for.
Also, you can check this thread - https://forum.uipath.com/t/get-current-robot-schedules-in-the-orchestrator/18333

1 Like
3

Hi Silviu,

Thank you for your response.
We don’t have the Orchestrator API installed.
Is it possible to get this info via sql query?
or how to add the quartz library to Uipath?

4

Orchestrator API is installed by default, the interface you are using to work with Orchestrator is build on top of the same API. Check the API guide here - About OData and References.

Regarding the database structure, I have no idea how it is structured or how to build the SQL queries.

Here is a guide on how to include external libraries in UiPath Studio - https://www.uipath.com/kb-articles/how-to-include-external-dll

5

Thank you very much.

I will check these options.

Warm Regards,

Pravinraj Vincent

6

Page not found for V2016.2

7

To call API from SQL use below SQL functions

1 Like