Excluding processes from alert - REGEX question

thedavegray

Hi,

Not that good when it comes ti using REGEX. I would like to exclude completely any "Long Running Query" alerts if the process name is "Database Mail - Database Mail" as in the example. I've created a regex but does not seem to work. Any ideas?

Dave

^(?=DatabaseMail - DatabaseMail - Id)

aovp

I am no regex master either, but I do something similar to remove any alerts for long running backups...to do so, I entered the following [BACKUP], and it works for me. You might try something similar...like [Database Mail]. This should remove anything what that name from the alerts.

Hope this helps.

thedavegray

Hi,
So just [Backup], no quotes or any other regex characters?

chriskelly

The more simple the regular expression the better. If you select the blue '?' next to the field it gives you some examples, including [Bb]ackup which will match both 'backup' and 'Backup'. There is also two links to some help there.