October 17, 2019 at 9:32 pm
Is there a better way to Automate Monitoring SQL Server Error Logs with Email Alerts. This is what i found, unless anyone has a better solution than this? Thanks in Advance!
October 18, 2019 at 2:43 pm
I could able to setup using the above link. However, my understanding SQL Server error logs entries for database time outs as well right caused by network glitch or any other reason, so i can able to setup for that as well right?
October 18, 2019 at 4:43 pm
What I tend to do is use the Alerts ability within SQL Server Agent to get notifications of errors.
https://docs.microsoft.com/en-us/sql/ssms/agent/alerts?view=sql-server-ver15
You can setup an Alert for errors of severity 19 through 25, or any error that writes to the error log. Here's another article explaining how to use them:
https://sqlperformance.com/2015/02/sql-alert/sql-server-agent-alerts
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply