How to delete all alerts in a category

Monitor, diagnose and receive alerts to problems across your SQL Servers.

Moderators: eddie davis, david connell, dlkj, Colin Millerchip, priyasinha, Emma A

How to delete all alerts in a category

Postby MartinH » Wed May 12, 2010 8:19 am

I would like to permanently delete all alerts in a given category, how should I go about this?

TIA,
Martin.
MartinH
 
Posts: 64
Joined: Fri Apr 15, 2005 9:13 am

Postby Chris Auckland » Thu May 13, 2010 1:49 pm

Thanks for your post.

If you edit the Alert Template under 'configuration' in the UI, then you can disable the alerts you don't want to recieve.

Any alerts that are already showing in the UI will need to be cleared.

I hope this helps.
Chris
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.

Postby MartinH » Thu May 13, 2010 3:50 pm

Chris:

Hmm, I'm not sure I have explained myself very well.

I have an alert about a long running query (> 1400 alerts). I have changed the program to resolve this issue, but I still wish to continue to monitor this alert, I just want to eliminate the 1400 previous alerts.

Thanks,
Martin.
MartinH
 
Posts: 64
Joined: Fri Apr 15, 2005 9:13 am

Postby Chris Auckland » Mon May 17, 2010 8:34 pm

You can multiselect all the alerts you want to clear in the UI, then right-click -> Clear Alert.
Chris
Chris Auckland
 
Posts: 757
Joined: Tue Oct 24, 2006 2:12 pm
Location: Red Gate Software Ltd.

Re:

Postby MartinH » Tue May 18, 2010 7:50 am

Chris Auckland wrote:You can multiselect all the alerts you want to clear in the UI, then right-click -> Clear Alert.


Thanks Chris, that solved my problem. I didn't know the multiselect was available.

Regards,
Martin.
MartinH
 
Posts: 64
Joined: Fri Apr 15, 2005 9:13 am


Return to SQL Response 1

Who is online

Users browsing this forum: No registered users and 0 guests