June 13, 2011 at 6:37 am
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
June 13, 2011 at 8:27 am
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
June 14, 2011 at 11:49 pm
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
June 15, 2011 at 4:51 am
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
June 15, 2011 at 5:49 am
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/
June 15, 2011 at 6:48 am
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
June 15, 2011 at 11:01 am
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/
June 15, 2011 at 10:13 pm
Thank you Muthukkumaran.i will utilize this procedure.
Bye
Regards
venkat
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply