Alert table em_alert

George18 · ‎11-14-2023

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 · ‎11-14-2023

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

Please mark this response as correct and helpful if it helps you can mark more that one reply as accepted solution

AshishKM · ‎11-14-2023

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

Please mark this response as correct and helpful if it helps you can mark more that one reply as accepted solution