How to fetch 7 update scheduletime of scheduler using services?

[AP_10343008]

1. How to fetch scheduletime of scheduler using services?

2. How to update scheduletime of scheduler using services

[Rocko · Accepted solution]

// getting the config table
let table=Things["sched1"].GetConfigurationTable({tableName:"Settings"});

// setting the value
table.schedule="0 4 0/1 * * ?";
Things["sched1"].SetConfigurationTable({
	tableName: "Settings", configurationTable: table,
});

// returning the value
result=Things["sched1"].GetConfigurationTable({tableName:"Settings"}).schedule;

[AP_10343008]

If I updated the value "0 44 11 ? * WED" for scheduled time through service, subscription is not triggering automatically. But If i manually update scheduler with the same  scheduled time "0 44 11 ? * WED" subscription is triggering automatically. What is the issue.

[Constantine]

Try to restart the scheduler thing after the update.

[AP_10343008]

This is the code i used to set the scheduler. The CRON String is updating correctly. But subscription is not triggering.

Code:

try{

TimeInHours = parseInt(TimeInHours);

let DayofWeekValueArray = ["SUN", "MON", "TUE", "WED", "THU", "FRI", "SAT"];

const exists = DayofWeekValueArray.includes(DayOfWeekValue);

if(exists==true && TimeInHours<24 && TimeInMinutes<60){

    // getting the config table

    let table=Things["AutoGenerationReport-Scheduler"].GetConfigurationTable({tableName:"Settings"});

    let CRONString = "0 "+TimeInMinutes+" "+TimeInHours+" ? * "+DayOfWeekValue;

    logger.info("SetScheduledTime: CRONString is "+CRONString);

    // setting the value

    table.schedule=CRONString;

    table.enabled = enabled;

    Things["AutoGenerationReport-Scheduler"].SetConfigurationTable({

        tableName: "Settings", configurationTable: table, persistent: true

    });

    result=true;

}

    else  result=false;

}catch(e){

logger.warn("SetScheduledTime: error is "+e+" in linenumber "+e.lineNumber);

    result=false;

}

[Constantine]

Try to call Things["AutoGenerationReport-Scheduler"].RestartThing(); right before setting result to true.

[AP_10343008]

Yes. It is working now. Thank you.

[Rocko]

I'll get that added to the article.

[Rocko]

it's also documented here https://www.ptc.com/en/support/article/CS399188

[AP_10343008]

How to find the services of Datashapes, Projects, ModelTags services quickly? Any documentation is there to go through all of these services in one go ?

[Rocko]

Not sure what you mean. That is what the Services tab is for?

Plus you can consult the API documentation: http://support.ptc.com/help/thingworx_hc/javadoc/