---
sourceDocument: Zurich IT Operations Management
sourceDocumentLink: https://www.servicenow.com/docs/r/zurich/it-operations-management

 Release :

    - zurich

ft:locale :

    - en-US

ft:publication_title :

    - Zurich IT Operations Management

ft:clusterId :

    - itom

bundleId :

    - itom

workflow :

    - Technology


---

# Clean alert history and impact status tables

# Clean alert history and impact status tables {#ariaid-title1}

* Release version: Zurich
* 
* Updated July 31, 2025
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read

Schedule jobs to mark and remove old alert records in the Alert History
\[em_alert_history\] and Impact Status \[em_impact_status\] tables, to prevent the tables from
becoming overloaded with data.

## Before you begin

Role required: evt_mgmt_admin

## About this task

Schedule the following jobs to remove old alert records:

* Backfill: Determines when alerts are to be marked for deletion.
* Clean: Deletes the alerts.

{#clean-alert-tables__ul_ckw_4ct_trb}  
Note:  
The records in the \[em_alert_history\] and \[em_impact_status\] tables are deleted by default after three months. This is controlled by the properties evt_mgmt.impact_calculation.cleanup_age_seconds.em_alert_history and evt_mgmt.impact_calculation.cleanup_age_seconds.em_impact_status. The default value is 7,776,000 seconds (equivalent to 90 days).

## Procedure

1. Navigate to AllSystem DefinitionScheduled Jobs.  
   The Scheduled Jobs page appears.
2. To determine how often to mark alerts for deletion on the Impact Status table:
   1. Locate and select the Event Management - Backfill Impact Status Table job.  
      The Scheduled Script Execution page appears.Figure 1. Scheduled Script Execution page   

   2. In the Repeat Interval field, configure how often you want the job to run.  
      To run the job immediately, select Execute Now.
   3. Select Update.
   {#clean-alert-tables__substeps_drm_s2t_trb} {#clean-alert-tables__2}
{#clean-alert-tables__2}
3. To remove old alerts from the Impact Status table:
   1. Locate and select the Event Management - Clean Impact Status Table job.  
      The Scheduled Script Execution page appears.   

   2. In the Repeat Interval field, configure how often you want the job to run.  
      To run the job immediately, select Execute Now.
   3. Select Update.
   {#clean-alert-tables__substeps_xsj_m5t_trb} {#clean-alert-tables__3}
{#clean-alert-tables__3}
4. Repeat steps [2](https://www.servicenow.com/docs/bd1YdooTWPJxvVU4yJwFVw#clean-alert-tables__2) and [3](https://www.servicenow.com/docs/bd1YdooTWPJxvVU4yJwFVw#clean-alert-tables__3) to perform the Backfill and Clean jobs on the Alert History Table.

*[\>]: and then