As mentioned by others, REST APIs will help (in case you're on the right version). Please find below an example via Postman and another via cURL to retrieve a schedule details and update them. Change {{ip_address}} and {{port}} accordingly as well as the schedule name and parameters. You may identify values to be changed because are underlined.
Hope it helps.
/*** Retrieve Adapter status: API Sampe ***/
http://{{ip_address}}:{{port}}/B2BAPIs/svc/schedules/?searchFor=FSAxxx
/*** Retrieve Adapter status: API Sampe via cURL***/
curl --location --request GET 'http://{{ip_address}}:{{port}}/B2BAPIs/svc/schedules/?searchFor=FSAxxx' \
--header 'Content-Type: application/json' \
--header 'Accept: application/json' \
--header 'Authorization: Basic xxxxxxxx='
/*** Update Adapter status : API Sampe ***/
http://{{ip_address}}:{{port}}/B2BAPIs/svc/schedules/FSAxxx
{
"scheduleType": "Service",
"timerOrClock": "Timer",
"system": "node1",
"excecutionDay": "Every Day",
"runAtStartUp": {
"code": true,
"display": "Yes"
},
"runAsUser": "admin",
"timerSchedule": {
"hours": 2,
"minutes": 0
},
"scheduleStatusEnabled": {
"code": true,
"display": "No"
}
}
/*** Update Adapter status : API Sampe via cURL ***/
curl --location --request PUT 'http://{{ip_address}}:{{port}}/B2BAPIs/svc/schedules/FSAxxx' \
--header 'Content-Type: application/json' \
--header 'Accept: application/json' \
--header 'Authorization: Basic xxxxxxxx=' \
--data-raw '{
"scheduleType": "Service",
"timerOrClock": "Timer",
"system": "node1",
"excecutionDay": "Every Day",
"runAtStartUp": {
"code": true,
"display": "Yes"
},
"runAsUser": "admin",
"timerSchedule": {
"hours": 2,
"minutes": 0
},
"scheduleStatusEnabled": {
"code": true,
"display": "No"
}
}'
------------------------------
Emiliano Pacelli
------------------------------
Original Message:
Sent: Mon December 19, 2022 04:44 AM
From: Sach NA
Subject: Automate the Enable/Disable Schedulers in Sterling Integrators
Thanks for the reply. Any other option do we have other than SCHEDULER TABLE update?
Original Message:
Sent: 12/19/2022 1:03:00 AM
From: Manuel Frank
Subject: RE: Automate the Enable/Disable Schedulers in Sterling Integrators
Hi,
opscmd was also the first thing that came to my mind but did not find anything related to schedules there.
What would be possible is to change the status in the DB directly although that would not be recommended by IBM :-)
The table is SCHEDULE.
Best regards
Manuel
------------------------------
Manuel Frank
Integration Architect
Andreas STIHL AG & Co. KG
Waiblingen
------------------------------