Release : 12
Component : CA Workload Automation AE (AutoSys)
Issue was caused by a change to exadata time zone to CDT from EDT.
Times of AEDB and Scheduler are not in sync.
The following messages are observed from the scheduler log:
[09/17/2020 08:46:29] CAUAJM_I_40218 **** Time offset between AutoSys and Event Server 1 is 3,600 seconds. ****
[09/17/2020 08:46:30] CAUAJM_I_40211 Using TZ = America/New_York.
Scheduler:
$ date
Thu Sep 17 16:19:38 EDT 2020
Database:
SQL> SELECT SESSIONTIMEZONE, CURRENT_TIMESTAMP FROM DUAL;
SESSIONTIMEZONE
---------------------------------------------------------------------------
CURRENT_TIMESTAMP
---------------------------------------------------------------------------
-04:00
17-SEP-20 04.16.57.073879 PM -04:00
Note: The CURRENT_TIMESTAMP returns the current date and time in the session time zone not the system date and time.