Need an SQL query to trim the alerts that are not clearing automatically

[lisareinhart]

Need an SQL query to trim the alerts that are not clearing automatically, especially the job finalized alerts.

[tom_sprouse · Accepted solution]

Lisa, 

Clearing the alerts via SQL will not work via Opscenter WebUI... you will need to use loadsql.bat or dbisqlc application to clear them using SQL.

However, doing so is not supported nor recommended... 

The recommended method is via the WebUI... 

To make life a little easier, go to Monitor / Alerts ...

and click on the Change Table Settings Icon - far right of screen (table w/ green check box)

When the Table Settings Windows appears, change the Rows Per Page to 200... 

Click OK

This will allow more alerts to appear per page, and if you filter by Alert Policy / you can target clearing job finalized alerts in batches of 200... 

--Tom

[lisareinhart]

Thanks Tom!