Re: SQL Agent Failure - monitoring

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Keith Langmead (klangmead_at_nospam.kms.co.uk)
Date: 10/25/04 

Date: Mon, 25 Oct 2004 17:00:50 +0100

I looked at this myself a year or so ago. I ended up writing a script which
goes through, checks if the SQLAgent service is running, and if it isn't
automatically starts it for you. It also e-mails a notification to you, so
1) you know that something caused it to die, and 2) if you keep getting
notified you know that for some reason the service has been unable to
re-start / keeps failing after it has been started.

If you fancy a copy of it let me know and I'll e-mail it to you.

Keith

"CR" <CR@discussions.microsoft.com> wrote in message
news:8081874F-E175-4B40-ABDB-92C695FBC10B@microsoft.com...
> Found the answer to my problem in case anyone also was wondering:
>
> the NT Event Log is written to automatically when a service terminates
> unexpectedly or fails to start.
>
> "CR" wrote:
>
> > Hi,
> > I want to log to the Windows Event Log whenever the SQL Server Agent is
> > stopped or fails. This is in case it does not come up successfully
after a
> > re-boot, or it just fails unexpectedly.
> >
> > What I have done so far:
> >
> > I have set the agent to AutoStart when the OpSys restarts, and also to
> > re-start the Agent if it stops unexpectedly (via Enterprise Manager -
Agent
> > properties)
> > I have experimented with Alerts, and alerting for error #20557 doesn't
seem
> > to work if the system is stopped correctly rather than fails.
> >
> > The missing scenario that I want to cater for is if the system is
stopped
> > correctly, but the Agent just doesn't restart.
> >
> > Can anyone tell me firstly if this is worth being concerned about, and
> > secondly how can I get it logged?

Relevant Pages

  • SQL Agent Failure - monitoring
    ... I want to log to the Windows Event Log whenever the SQL Server Agent is ... or it just fails unexpectedly. ... I have set the agent to AutoStart when the OpSys restarts, ...
    (microsoft.public.sqlserver.server)
  • RE: SQL Agent Failure - monitoring
    ... unexpectedly or fails to start. ... > I want to log to the Windows Event Log whenever the SQL Server Agent is ... > I have set the agent to AutoStart when the OpSys restarts, ...
    (microsoft.public.sqlserver.server)
  • Problem w/ explorer.exe not working on Win2k, SP4
    ... I have a problem with my Win 2000 ProWorkstation. ... to startup and then quickly fails (it flashes a display of the ... msg in the event log which states drive D is running low on space, ... even though it has 15GB free space left. ...
    (microsoft.public.win2000.file_system)
  • .Net Windows Service Issue
    ... I have created a windows service in VB.Net called 'Import Agent'. ... I changed the startup object in my project's properties from ... I am not directly writing to the Event Log, ...
    (microsoft.public.dotnet.general)
  • Re: Warning after dcpromo
    ... fails with the errors described in the KB for 40960. ...
    (microsoft.public.windows.server.active_directory)