Skip to main content
Sep 19, 2022 11:05 AM UTC
Solved

next scheduler executions / CRON

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?

danmorinAnswer
Sep 20, 2022 2:20 AM UTC

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

4 replies

danmorinAnswer
Sep 20, 2022 2:20 AM UTC

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

gchAuthor
Sep 20, 2022 6:20 AM UTC

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

Sep 20, 2022 9:03 AM UTC

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/