Purge System Generated Log job does not appear to not delete rows from CSR

Purge System Generated Log job does not appear to not delete rows from CSR_LOG table (4303871)

Return

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Title

Purge System Generated Log job does not appear to not delete rows from CSR_LOG table
Description

We have the PURGE SYSTEM GENERATED LOGS job running but it doesn’t appear to delete rows from the expected table CSR_LOGS.
It’s unclear if we:
- Have the job set up wrong
- Our expectation that ALL rows are being deleted from the CSR_LOGS based on the number of retention days as the only criteria for the
- There’s a problem with the job which is preventing the job from deleting the rows
We have the job running with 1 retention day against a table with 75915 rows of data. We have an expectation there should be a change in the number of rows after the jobs execute.
Cause

The Job runs as designed.
Resolution

This is the statement criteria the job uses to determine the rows to delete from CSR_LOG table:
DELETE FROM CSR_LOG
WHERE SD_CD=?
AND EFFDT < ?
AND UPDATE_USERID ='SYSTEM'
AND LOG_TOPIC NOT IN ('Stat Mail-Out','Stat Mail-In','Stat Status-App', 'Stat Migr-App','Stat Patch-App')
This explains the criteria about what rows will be deleted.

Feedback Submitted

Did this article solve an issue for you?

Select Rating

Purge System Generated Log job does not appear to not delete rows from CSR_LOG table (4303871)