July 2, 2018 at 11:22 am
I setup some SQL alerts in SQL out of box alerts. No 15 is SQL Errors.
I got the alert in my email for a server saying below, but that is too little info.
How can I find out about more information about this SQL Errors?
I checked in SQL log, no errors.
Subject: SQL Server Alert System: 'SQL Errors' occurredon \\myservername
DATE/TIME: 7/2/201810:16:19 AM
DESCRIPTION: (None)
COMMENT: (None)
July 2, 2018 at 2:39 pm
sqlfriends - Monday, July 2, 2018 11:22 AMI setup some SQL alerts in SQL out of box alerts. No 15 is SQL Errors.I got the alert in my email for a server saying below, but that is too little info.
How can I find out about more information about this SQL Errors?
I checked in SQL log, no errors.Subject: SQL Server Alert System: 'SQL Errors' occurredon \\myservername
DATE/TIME: 7/2/201810:16:19 AM
DESCRIPTION: (None)
COMMENT: (None)
I don't have a message id 15 - is that the message id or the severity? I think all of the built in messages have text which would populate the description so I'm not sure about that one in particular.
The description on the alert would be the text in sys.messages. And the comments come from the Options page on the alert - additional notification message to send.
So those are the pieces you have for information on the alerts.
Not all errors are logged. You can find which ones are logged by looking at the catalog view sys.messages. It has an event_is_logged column.
Sue
July 2, 2018 at 3:13 pm
sorry it is severity 15.
I am looking at thge table sy.messages , all the severity 15 has an is_event_logged =0, but how can I find from email which message_id is it?
All the fields seems blank in the email.
Thanks.
July 2, 2018 at 3:41 pm
sqlfriends - Monday, July 2, 2018 3:13 PMsorry it is severity 15.I am looking at thge table sy.messages , all the severity 15 has an is_event_logged =0, but how can I find from email which message_id is it?
All the fields seems blank in the email.Thanks.
Usually you can tell from the description and the subject in the email. I know text is not null in the sys.messages view so that seems a bit unusual. I think the description will not include the event message if you don't select Include Error Text in (Email, Pager, Net sent)....the first one on that options page for the alert. You may want to check if that is selected since that would give you the text from sys.messages and would be listed in the description for the email. Then it's pretty easy to track it down.
Anyway to try to track it down from what you have, there is a sysalerts table in msdb. It should have all of the alerts you have setup, defined. There are last occurrence date, last occurrence time columns in that table. If something is sent in response, those are in the sysnotifications table in msdb but that's not likely to help you much so I'd just focus on the sysalerts.
Did this alert fire in response to a user defined message?
Sue
July 2, 2018 at 5:40 pm
Sorry I checked in the sysalert table, now I think the id in this table is 18 called SQL errors.
But all alerts I setup have options to include error text in email.
I did not set up fire alert in response to user defined message, just choose
018 - Nonfatal Internal Error
July 3, 2018 at 11:48 am
sqlfriends - Monday, July 2, 2018 5:40 PMSorry I checked in the sysalert table, now I think the id in this table is 18 called SQL errors.But all alerts I setup have options to include error text in email.
I did not set up fire alert in response to user defined message, just choose
018 - Nonfatal Internal Error
Thanks for explaining things - I get it now how you have it set up.
What's odd though is that the only way I get nothing in the Description sent is if I don't have "Include Alert Error in" text enabled. Been testing and I haven't figured out another way to not have that description. So as of now, I have no idea why you aren't getting any more info. Sorry about that.
Sue
July 3, 2018 at 3:48 pm
Thank you.
Now I will just disable the alert, for it keeps sending me alert emails.
July 16, 2018 at 9:46 am
Actually after I disabled 11, 13, 15, 16, 18, I still got the alerts of SQL errors.
Not sure what is it, cannot find anything in SQL server log. So still have no clue how to trouble shoot.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply