Skip to main content
13-Aquamarine
September 19, 2022
Solved

next scheduler executions / CRON

  • September 19, 2022
  • 1 reply
  • 2377 views

Hello,

 

I need a functionality to determine the next execution date(s) of a scheduler based on it's cron and last execution date (or date range) but I could not find anything useable in Thingworx or Java. Having this capability I could provide an overview of the scheduled task to the End user.

Is there any tool that could help me to achieve this?

Best answer by danmorin

Hi 

 

Manually you can get the last execution date by creating a date time property that will be updated when the scheduler is triggered. That way it will keep the last execution date.

 

For the next execution date, you can get the cron schedule via service

 

let table = me.GetConfigurationTable({
tableName: 'Settings' /* STRING */
});
let result = table.schedule;

 

and then from the result you can create a function to determine the next execution date

 

Hope this helps, thanks

1 reply

danmorin1-VisitorAnswer
1-Visitor
September 20, 2022

Hi 

 

Manually you can get the last execution date by creating a date time property that will be updated when the scheduler is triggered. That way it will keep the last execution date.

 

For the next execution date, you can get the cron schedule via service

 

let table = me.GetConfigurationTable({
tableName: 'Settings' /* STRING */
});
let result = table.schedule;

 

and then from the result you can create a function to determine the next execution date

 

Hope this helps, thanks

gch13-AquamarineAuthor
13-Aquamarine
September 20, 2022

Yes it does, but we cannot findout the execution date in the future, for instance for next month?

1-Visitor
September 20, 2022

You need to make the logic by yourself to count the next date. or use this API calls which may help you https://docs.cron-job.org/rest-api.html https://cron-job.org/en/