ESP_WSS_JOB and ESP_WSS_APL tables are not deleted

[WOONGYO Han]

Hi teams.

HOUSEKEEPING_UTILUTY - PURGE_COMPLETED_JOB.OLDER_7_DAYS is successfully executed once a day, but the ESP_WSS_JOB and ESP_WSS_APL tables are not deleted from a specific date in the past. In this case, what should I check?
That is, the data in the ESP_WSS_JOB and ESP_WSS_APL tables continues to accumulate. Can I delete these tables manually using SQL delete?

If manual deletion is possible, please let me know the deletion SQL statement.

Also, is it possible to figure out why this table is not being cleared?

Thanks in advanced

WG

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

[Ravi Kiran Kunduri]

purgecompletedjobs cli command is the recommended way to remove records. If it is not working , it is better to investigate further. Can you please raise a ticket.

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

[SHARON SHIMANEK]

What is the actual argument to pass in your housekeeping utility job.  are the server, port, userid and password correct?

server port ADMIN adminpswd 'PURGECOMPLETEDJOBS olderthan("now less 7 days")'

what does the spool file look like, what mine looks like

              Purged 591 completed applications from the repository.

also, in your dseries logs directory check the clilog for the date/time the purge completed jobs command was run. This gives more info than the spool file 

clilog.2025-09-18_03.30.41.509.txt

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

[SHARON SHIMANEK]

Hi Woongyo,

what is the actual cli command you are running? what does the spool file or cli console show for Purged xxx completed applications from the repository?

'purgecompletedjobs "now less 6 days"'

Purged 591 completed applications from the repository.

Sharon

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