Automate Monitoring SQL Server Error Logs with Email Alerts

Question

Automate Monitoring SQL Server Error Logs with Email Alerts

kvr1985

SSCommitted

Points: 1628
More actions
June 13, 2011 at 6:37 am

#145815

HI guys,
How to montoring sql server error log Every three hours.I found the script from one site.But that is not working.Is there any procedures.
Regards
venkat

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Grant Fritchey SSC Guru Points: 398952 More actions · Answer 1

How do you mean? Do you want alerts when there are errors? You can configure this using Alerts in SQL Agent.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

kvr1985 SSCommitted Points: 1628 More actions · Answer 2

Grant Fritchey (6/13/2011)
How do you mean? Do you want alerts when there are errors? You can configure this using Alerts in SQL Agent.

Hi,

Because In my company I am only SQL DBA.I need check every thing in sql server.so i have to create procedure for every 2 hours monitoring sql server error log.If sql server error log contain any errors send the errors to mail using procedure. I got one script from MSSQLTIPS.but this is not working.please give me the suggestion. please check the below link.

http://www.mssqltips.com/tip.asp?tip=2307

Regards
venkat

Grant Fritchey SSC Guru Points: 398952 More actions · Answer 3

Instead of checking the error log every two hours, why don't you just have the errors forwarded to you directly. Then you know about them when they happened rather than trying to figure out later. This is the approach I usually use. http://msdn.microsoft.com/en-us/library/ms188235.aspx

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning

muthukkumaran Kaliyamoorthy SSCoach Points: 19026 More actions · Answer 4

i second that grant. Alert is good option but it's not work all the cases.

If you want you can use my beat version Sproc and add the errors whatever, you thing as critical.

How to get the SQL server critical errors via mail using native T-SQL Script

[/url]

Let me know how it goes.

Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/

kvr1985 SSCommitted Points: 1628 More actions · Answer 5

muthukkumaran Kaliyamoorthy (6/15/2011)
i second that grant. Alert is good option but it's not work all the cases.
If you want you can use my beat version Sproc and add the errors whatever, you thing as critical.
How to get the SQL server critical errors via mail using native T-SQL Script
Let me know how it goes.

thank you for the reply.I have executed the procedure in my server.when i am executing the procedure like

exec usp_dba_critical_error

exec usp_dba_critical_error_DBmail

i am getting is 0 is affected.Is it correct?

Regards
venkat

muthukkumaran Kaliyamoorthy SSCoach Points: 19026 More actions · Answer 6

kvr1985 (6/15/2011)
muthukkumaran Kaliyamoorthy (6/15/2011)
i second that grant. Alert is good option but it's not work all the cases.
If you want you can use my beat version Sproc and add the errors whatever, you thing as critical.
How to get the SQL server critical errors via mail using native T-SQL Script
[/url]
Let me know how it goes.
thank you for the reply.I have executed the procedure in my server.when i am executing the procedure like
exec usp_dba_critical_error
exec usp_dba_critical_error_DBmail
i am getting is 0 is affected.Is it correct?

This means you didn't have any critical errors. as i already said you can add errors in error table whatever you think as critical.

Muthukkumaran Kaliyamoorthy
https://www.sqlserverblogforum.com/

kvr1985 SSCommitted Points: 1628 More actions · Answer 7

Thank you Muthukkumaran.i will utilize this procedure.

Bye

Regards
venkat