Last week we had some problems with table ACT_HI_JOB_LOG. It was filled with +250mil rows. So we truncated the table and configured some cleaning and TTL jobs.
But after a week there are +50mil rows again. And I see a lot of rows with JOB_DEF_TYPE_ = batch-monitor-job with [REMOVAL_TIME_] and [PROCESS_DEF_ID_] equals NULL. these aren’t cleaned with the traditional jobs.
So I have a few questions :
- were are these rows coming from ?
- were can we configure these loggings of this type so we can reduce the amount of rows they return in this table.