Alert table em_alert

[George18]

Hi,

I am aware that events are kept for 5 days and alerts for 90 days,

I was able to find what purges the events in the table rotation. 

But, I am unable to find out what purges alerts after 90days.

Can you please provide me with the job name, business rules which does this task?

I would like to know what time of the day it runs.

Thank you

[AshishKM · Accepted solution]

Hi @George18 ,

Please check at table [ sys_auto_flush ] for retention policy details. 

The  scheduled job that invokes the Table Cleaner (sys_auto_flush) as below, you can check in table ( sys_trigger), this job runs every hour.

-Thanks,

AshishKMishra