Sunday, September 8, 2013

[SQL Server 2008 issues] Automate Monitoring SQL Server Error Logs with Email Alerts

[SQL Server 2008 issues] Automate Monitoring SQL Server Error Logs with Email Alerts


Automate Monitoring SQL Server Error Logs with Email Alerts

Posted: 07 Sep 2013 05:30 AM PDT

Hi I'm using the below 2 stored procedures for Automate Monitoring SQL Server Error Logs with Email Alerts. http://www.mssqltips.com/sqlservertip/2307/automate-monitoring-sql-server-error-logs-with-email-alerts/It works great but it is not sending email when there is an backup failure error in error log For example, I can see the below error in error log but the script is unable to send this error information in email.. Please adviseError: 3041, Severity: 16, State: 1.2013-09-05 15:18:52.95 Backup BACKUP failed to complete the command BACKUP DATABASE admi. Check the backup application log for detailed messages.

No comments:

Post a Comment

Search This Blog