Options

Excluding processes from alert - REGEX question

thedavegraythedavegray Posts: 18
edited November 14, 2014 4:38AM in SQL Monitor Previous Versions
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)
· Share on Twitter

Comments

  • Options
    aovpaovp Posts: 5
    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.
    Brian Jenkins
    · Share on Twitter
  • Options
    thedavegraythedavegray Posts: 18
    Hi,
    So just [Backup], no quotes or any other regex characters?
    · Share on Twitter
  • Options
    chriskellychriskelly Posts: 378
    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.
    · Share on Twitter
Sign In or Register to comment.