The ESP_APPLICATION table contains data of all the application generations that have been ever ran by CA Workload Automation DE. The following SQL statement does not work on MS-SQL:
DELETE from ESP_APPLICATION where END_DATE_TIME < TO_DATE('2010-09-01','YYYY-MM-DD') and STATE like 'COMPLETE';
Note: In 12.1 and above use Movehistorydata command to clear data.
Component: Workload Automation DE
To clear the ESP_APPLICATION table on MS-SQL database, the user can use the following query:
DELETE from ESP_APPLICATION where END_DATE_TIME < '2010/09/01' and STATE like 'COMPLETE';
Note : Before issuing the above command, please backup your database. The dSeries server must not be running. It is also recommended to move all the older entries to some other location for any future consultation or auditing requirements.