May 28, 2003 at 9:16 am
I had a situation, that the jobs were not running. In Services, the SQLSERVERAGENT was started already. But, in EM, SQL Server Agent under Management Console was in red. Is there a way to create alert/notification to monitor the agent, so that when it goes down i can be notified? Thanks in advance.
May 28, 2003 at 9:27 am
Since the agent does the alerting, it cannot alert you if it goes down. Did you start the agent and then check EM? Sometimes takes a minute or two to refresh that.
If this is Widows 2K or better, you can set the service to restart itself if it fails. As far as an alert mechanism, you'd need to build something eles to do that.
Steve Jones
May 28, 2003 at 9:40 am
Yes the agent was setup as manual startup, and we had a abnormal shutdown.
I use win2k. Anyone faced a similar problem, and found a solution to this?
May 28, 2003 at 2:07 pm
I agree w/ Steve.
Try setting something up through NT to check the service. Maybe through the command line and NET START w/ an e-mail program like BLAT, or using Perl, or something else. Or how about an external monitoring tool?
There are a lot of ways to approach this, but the low down is that you won't be able to have a SQL Server Agent Service monitor itself.
"Keep Your Stick On the Ice" ..Red Green
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply