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?
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%';