ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

autorep command takes long time to process


Article ID: 112116


Updated On:


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


When running autorep to create a report on jobs, the experience is that it is taking an excessive amount of time to receive the data from the database.


This is likely attributed to the deletion of a large amount of data from the database.


Any OS
Any DB
Any release of Workload Automation AE.


As a Best Practice, whenever a large amount of data is cleared from the database, it is usually a good idea to run the script which is located in the $AUTOSYS/dbobj directory. It will improve performance.

Additional Information

Reference for additional details.