regular expression SQL Server log entry Alert
lcarpay_hp
Posts: 1 New member
hi, what I want to do is to raise an alert in SQL Monitor when custom error with message_id=63999 is raised via RAISERROR(63999,1,1) or with severity 11 for that matter RAISERROR(63999,11,1) .
I found the alert settings in which I can:
"Raise a [medium] alert when a log entry message matches one of the following regular expressions".
I configured the alert just for this instance, just the littoral 63999 as the regular expression but it doesn't seem to raise the alert.
I found the alert settings in which I can:
"Raise a [medium] alert when a log entry message matches one of the following regular expressions".
I configured the alert just for this instance, just the littoral 63999 as the regular expression but it doesn't seem to raise the alert.
Tagged:
Answers
Can you send a screenshot of the custom metric and alert you configured? Also, what version of SQL Monitor are you using?
Thanks!