delete specific date - ESP_WSS_JOB, ESP_WSS_APPL

[WOONGYO Han]

Hi team.

Is it okay to delete a completed job list using the SQL statement below?

(1) delete specific date - ESP_WSS_JOB

delete from esp_wss_job where appl_id in (select appl_id from esp_wss_appl where to_char(complete_date_time,'YYYYMMDD') = '20250701');

 

(2) delete specific date - ESP_WSS_APPL

delete from esp_wss_appl where to_char(complete_date_time,'YYYYMMDD') = '20250701');

 

Is it okay to delete a completed job using the SQL statement below?

Thanks

WG

-------------------------------------------

[Nitin Pande]

Hi,

Any particular reason you want to delete manually?

It is NOT recommended to delete records from WSS tables manually.  Use purgecompletedjobs command for any cleaning DB.  If you see any applications are stuck, then use cold start level 3 to remove stuck applications.

HTH,

Nitin Pande

------------------------------
Support
Broadcom
Toronto
------------------------------