autorep command takes long time to process

Document ID : KB000112116
Last Modified Date : 27/08/2018
Show Technical Document Details
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.
Any OS
Any DB
Any release of Workload Automation AE.
This is likely attributed to the deletion of a large amount of data from the database.
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.