Database log cleanup job is not deleting any data

(0) Share

Report

Posted on by Community member

I have schdeuled Database log cleanup job with the filters tableId 4056 (Numbersequence Table) and log type update. However its not deleting any data. I checked in the SysDataBaseLog table there are 3 million records in this table with this criterea. but its not getting deleted and the job is getting ended in 1 minute.

All responses (1)

Answers (0)

Suggested answer

GirishS 27,832 Super User 2024 Season 1 on at

Like (0)

Report

Database log cleanup job is not deleting any data

Hi,

I would suggest you to debug the class which is related to that dialog.

I am thinking that there is a field named "DatabaseLogCleanUpTopN" in the table DatabaseLogParameter table.

In the init method of the DataSource they are initializing that field value with 5000. So, I think the deletion of record is restricted to 5000.

I am not sure on that, but you can debug the code to get better idea on that.

Thanks,

Girish S.