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.
Remove old data from ESP_APPLICATION in DE (ESP dSeries) with MS-SQL DB
Article ID: 19314
Updated On:
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.
Feedback
Yes
No
Powered by
