| Author |
Anyway to track SQL Server Agent error messages
|
|
| jsheldon via SQLMonster.com 2006-11-07, 7:12 pm |
| We are in on SQL2000 and our SQL Server Agent started to receive errors for
Mail Profile not available. It wasn't until we looked at the agent error log
we saw the problem.
Is there any way to report the SQL Server Agent Warnings/Errors via email or
alert as a pro-active stance?
JTS
--
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Fo...server/200611/1
| |
| Netmon 2006-11-07, 7:12 pm |
| There is product called ProIT 4 (I work for the company and wrote the SQL
monitoring function in it) that will do it. ProIT is a server & network
monitoring software package. In additionally to writting it, we use it
internally and have customers using it to monitor both the sql error log and
the system eventlogs for SQL Agent job failures and SQL errors.
"jsheldon via webservertalk.com" wrote:
> We are in on SQL2000 and our SQL Server Agent started to receive errors for
> Mail Profile not available. It wasn't until we looked at the agent error log
> we saw the problem.
>
> Is there any way to report the SQL Server Agent Warnings/Errors via email or
> alert as a pro-active stance?
>
> JTS
>
> --
> Message posted via webservertalk.com
> http://www.webservertalk.com/Uwe/Fo...server/200611/1
>
>
| |
| jsheldon via SQLMonster.com 2006-11-08, 7:12 pm |
| Netmon what is the web address?
Thanks
Netmon wrote:[color=darkred
]
>There is product called ProIT 4 (I work for the company and wrote the SQL
>monitoring function in it) that will do it. ProIT is a server & network
>monitoring software package. In additionally to writting it, we use it
>internally and have customers using it to monitor both the sql error log and
>the system eventlogs for SQL Agent job failures and SQL errors.
>
>[quoted text clipped - 4 lines]
--
Message posted via http://www.webservertalk.com
|
|
|
|