Process to fetch old Job run information from DB

Products

• Autosys Workload Automation

Issue/Introduction

How do you go about finding old stale jobs or jobs that have never been run before?
We are trying to preform regular mainteance on our jobs to keep them clean and need to know how to find this information.

 

 

Environment

Autosys 12.x 11.x

Resolution

Out-of-the-box Autosys is designed to only keep the last 7 days of job information in the database.
This is controlled by your configuration in the $AUTOSUSER\config.$AUTOSRV file

https://techdocs.broadcom.com/us/en/ca-enterprise-software/intelligent-automation/autosys-workload-automation/12-0-01/administrating/ae-administration/configure-an-event-server/dbmainttime-and-dbmaintcmd.html

So unless you have changed your configuration to hold more data the information from 2 years ago will not be in the database.

When you run the dbmaint we archive some of the data to the $AUTOUSER/archive but this is NOT the full detail.

If you have some automated process to clean this directory up as well there will be no place else this information will be.