Daylight Savings Time with WAAE Timezone Attribute

Products

• CA Workload Automation AE - Business Agents (AutoSys)
• CA Workload Automation AE - Scheduler (AutoSys)
• Workload Automation Agent

Issue/Introduction

We have jobs that are using the CST6 timezone. The jobs are running fine now but we did run into some other issues dealing with other timezones, such as those using GMT-2. 

Is it better to use CST6CDT timezone over CST6? Why is one preferred over the other?

Environment

CA Workload Automation AE r11.3.6 SPX

Resolution

It's recommended to use CST6CDT. The CST6CDT timezone observers/recognizes DST and adjusts accordingly. It also allows countries or locations that don't observe DST to use only ST. CST6 does not recognize DST and would require a manual adjustment for the locations that do observe DST. 

 

For a listing of the timezones that recognize DST, run the following query against your AEDB:

 

[SQL SERVER] SELECT * FROM dbo.ujo_timezones WHERE zone LIKE '%DT%';

[ORACLE] SELECT * FROM AEDBAMDIN.ujo_timezones WHERE zone LIKE '%DT%';