autosys jobs getting stuck in starting state

Products

• CA Workload Automation AE - Scheduler (AutoSys)

Issue/Introduction

Jobs Getting stuck in Starting before processing to running

Status/[Event] Time Ntry ES ProcessTime Machine
-------------- --------------------- -- -- --------------------- ----------------------------------------
STARTING 11/20/2021 14:35:46 1 PD 11/20/2021 14:53:48 machine
RUNNING 11/20/2021 14:53:48 1 PD 11/20/2021 14:53:49 machine
<Executing at machine_PRD>

Environment

Release : 12.0

Component : CA Workload Automation AE (AutoSys)

Cause

Database slowness might impact such type of issues

Resolution

In Such Scenarios 

- Collect AWR Reports

- Engage DBAs to find the long running queries

- Solution could be identified mostly finding long running queries and performing Good Execution plans to tables that impacted