January 5, 2017 at 9:29 am
Company does not want to use sql server agent service (it will be disabled)
No 3-rd party tools allowed for monitoring
Number of servers instances involved in project 300+
All alerts of severity 13-25 must be captured and sent by email to level1 dba support team
same alerts can't be sent if raised within less then N numbers of seconds
I can parse sql server log using powershell and sent emails with alerts
Any other "generic" alert capture could be used?
Thanks
January 5, 2017 at 4:14 pm
They are certainly not making things easy. The "generic" approach is to use SQL Agent. I have never tried doing this without using Agent or a third party software.
If I were forced to, I think I'd look at the Service Broker as a mechanism for doing this rather than relying on scraping the error log (especially since for some severity errors, the error log won't be there since the server will be offline).
"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
January 5, 2017 at 9:56 pm
This was removed by the editor as SPAM
January 6, 2017 at 2:35 am
Hi
Don't know if this is a stupid idea (you are welcome to point and laugh) but it might work...
- Log the errors into a table
- write an on insert trigger that sends a mail to the support team with the details of the insert.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply