search cancel

The Process Time and Start Time do not match in an autorep -d command

book

Article ID: 5314

calendar_today

Updated On:

Products

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

Issue/Introduction

The process time and start time do not match. The autosys jobs are running 10 mins prior the the system timing. 

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   ibntestxxxxx.xxx.xxxxxcom.xxx

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.

Environment

Workload Automation AE 11.3.6/ Autosys workload automation 12.0

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.