ph_alert

IDS11.50 FC8. ph_alert got crazy and used too much disk there( attached some example rows of it). I need truncate it, but I want to hear any advice before I do since it is not my table . I believe I did its truncation before , just want to have double sure . How to refrain it's grow? Thanks, Frank id 1539432 alert_task_id 15 alert_task_seq 1538589 alert_type INFO alert_color YELLOW alert_time 2014-04-03 22:36:40 alert_state NEW alert_state_chang+ 2014-04-03 22:36:40 alert_object_type ALARM alert_object_name 18 alert_message Logical Log 208008 - Backup Completed alert_action_dbs sysadmin alert_action id 1539433 alert_task_id 15 alert_task_seq 1538590 alert_type INFO alert_color YELLOW alert_time 2014-04-03 22:51:07 alert_state NEW alert_state_chang+ 2014-04-03 22:51:07 alert_object_type ALARM alert_object_name 23 alert_message Logical Log 208010 Complete, timestamp: 0xc1f0bbe7. alert_action_dbs sysadmin alert_action id 1539400 alert_task_id 15 alert_task_seq 1538557 alert_type INFO alert_color YELLOW alert_time 2014-04-03 21:00:15 alert_state NEW alert_state_chang+ 2014-04-03 21:00:15 alert_object_type ALARM alert_object_name 18 alert_message Logical Log 207994 - Backup Completed alert_action_dbs sysadmin alert_action id 1539401 alert_task_id 15 alert_task_seq 1538558 alert_type WARNING alert_color YELLOW alert_time 2014-04-03 21:00:17 alert_state NEW alert_state_chang+ 2014-04-03 21:00:17 alert_object_type ALARM alert_object_name 48 alert_message /dbbackup/RepErr/ris.g_ngdcops.g_ncdcops.D_6415.140403_21:0 0:17.1|/dbbackup/RepErr/ats.g_ngdcops.g_ncdcops.D_6415.1404 03_21:00:17.2 alert_action_dbs sysadmin alert_action --001a11c13d64875fe004f6a33e8b

Hi, What does this statement in the sysadmin database show? select * FROM ph_threshold WHERE name = 'ALERT HISTORY RETENTION'; The value is a varchar that gets cast to an interval day to second. There should be a job in ph_task called 'Alert Cleanup' which gets called daily to purge table ph_alert. Ben.