The Process Time and Start Time do not match in an autorep -d command
Article ID: 5314
Updated On:
Products
Issue/Introduction
The process time and start time do not match. The autosys jobs are running 10 mins prior the the system timing.
Environment
Workload Automation AE 11.3.6/ Autosys workload automation 12.0
Cause
Be sure to check the database time and scheduler time to make sure that they are in sync. The process time in an autorep is the the database time.
autorep -J ca_test -d
Job Name Last Start Last End ST/Ex Run/Ntry Pri/Xit
________________________________________________________________ ____________________ ____________________ _____ ________ _______
ca_test ----- ----- ST 91096/1
Status/[Event] Time Ntry ES ProcessTime Machine
-------------- --------------------- -- -- --------------------- ----------------------------------------
STARTING 12/20/2021 08:20:02 1 PD 12/20/2021 08:20:23 testserver.company.com
You can check the current database time as follows
In MSSQL
SELECT CURRENT_TIMESTAMP AS current_date_time;
In Oracle
select CURRENT_TIMESTAMP from dual;
The start time will be the time given by the scheduler from the server's OS time.
Resolution
Make sure the time is sync on the database server and the scheduler.
If your database time is into the future , then you may need to plan for a Autosys downtime.
Firstt stop the autosys services consult your DBA if the database services needs to be stopped and then sync the time between scheduler and database machines.
Once database time and the autosys time is in sync then restart the autosys services.
Feedback
