How to remove old data from ESP_APPLICATION table with database on MS-SQL?

Document ID : KB000019314
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

The ESP_APPLICATION table contains data of all the application generations that have been ever ran by CA Workload Automation DE. This table does not get cleaned out by server, and will continue to get bigger as more and more jobs are executed. 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';

Solution:

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.