Some of the jobs contained within Schedules (JSCH) are executed twice or did not restart at all after period turnaround during Daylight Savings Time (DST). Possible symptoms include:
1. Schedule object refreshed over DST at 11 PM instead of 12 PM.
2. After refreshing, the Schedule executed jobs twice for the previous day, even though they successfully completed on time.
3. Some Job objects were not executed.
4. Some Schedule objects did not refresh at all.
Note: All information within this article relates specifically to the switchover to DST from Standard time (occurring in Spring).
If affected, restarting the schedules will resolve the issue for impacted schedules. Additionally, a script has been created to identify affected JSCH objects. The script will also provide update statements (one per object) to fix the turnaround time, which will correct the situation. This script was updated 29 March 2019 to cover additional situations.
In order to be able to import the objects, you need to have SQLVAR_INTERNAL set to YES in the UC_SYSTEM_SETTINGS.
The script needs to run after the DST and before the next period turnarround of the the JSCH.
An e-mail address can be defined in the top of the script to have a notification sent out in case faulty JSCH objects are found.
In case the Script identifies affected JSCH Objects, please execute the provided 'update' statement to fix it.
The script will not perform the update statement automatically for safety reasons.
You can easily grab the entire report and strip the timestamp at the beginning of the lines using a text editor to execute all statements with the tool of your choice.
Please don't forget to perform a 'commit' at the end, in cases the database used requires it.
A definitive fix is being worked on currently.
An example use of the script:
1.) DST is on Sunday 31st of March 02:00 am, period turnaround is at 00:00
2.) You need to wait until 3:00 am, so the DST should already happened
3.) Between the DST and the next period turnaround of your JSCH, you need to execute the script and execute the provided update statements.
We have identified this issue internally, and are working on a fix which will become available in the next releases for version 12.x (and the latest version 11.x), tentatively scheduled for release on the below dates:
Automation.Engine 12.2.2 HF2 - Available
Automation.Engine 12.1.4 HF2 - Available
Automation.Engine 12.0.7 HF1 - Available
Automation.Engine 11.2.10 HF1 - Available
Automation.Engine 12.0.8 - Available
Automation.Engine 12.1.5 - Available
Automation.Engine 12.2.3 - Available
Automation.Engine 12.3.0 - Available