Remove old data from ESP_APPLICATION in DE (ESP dSeries) with MS-SQL DB

Products

• DSERIES- SERVER
• CA Workload Automation DE - Scheduler (dSeries)

Issue/Introduction

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';

 

 

 

Environment

Release: 12.x
Component: Workload Automation DE

Resolution

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.