SQL Agent on Cluster stops

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Uni - 24 Jan 2006 05:06 GMT

I recently rebuilt my cluster (Server 2003 + SP)and installed SQL
Enterprise 2000 + SP3 on both matching nodes. Everything seems fine,
except on occasions the SQL Agent just shuts down with no error
messages in the logs and I have to go into Cluster Manager (or
Enterprise Manager) and restart it manually. I checked and SQL Agent
cluster properties are for it to restart itself after a period of time.

I'm not sure what's going on here.

Thanks,
Uni

Reply to this Message

Michael Hotek - 24 Jan 2006 14:05 GMT

I don't understand what you mean by installed SQL Server on both nodes. Do
you have 2 instances installed in the cluster?

There has to be an error message, somewhere. In the cluster logs, in the
event logs, in the SQL Agent logs, in the SQL Server logs, somewhere. Even
if someone manually shut it down, there is still an entry in the event logs.

Signature

Mike
http://www.solidqualitylearning.com
Disclaimer: This communication is an original work and represents my sole
views on the subject. It does not represent the views of any other person
or entity either by inference or direct reference.

>I recently rebuilt my cluster (Server 2003 + SP)and installed SQL
> Enterprise 2000 + SP3 on both matching nodes. Everything seems fine,
[quoted text clipped - 7 lines]
> Thanks,
> Uni

Reply to this Message

Uni - 24 Jan 2006 21:17 GMT

Sorry I did not make this clear. I installed SQL Enterprise on the
cluster. There is only one instance.

In the Server 2003 Event log, there is only a indication that the MS
SQL Agent Service Stopped at so-and-so time. It's not a fatal warning,
or anything. It does not restart itself.

Reply to this Message

Michael Hotek - 25 Jan 2006 18:09 GMT

There is a message that it stopped. WHY did it stop? Was it a request to
stop, did it abort, etc. There is never just one message. It either shut
down due to a stop service request or it threw some kind of error and shut
down. There should also be indications in the SQL Server error log as well
as the SQL Agent error logs. Things don't just spontaneously shut down,
something causes it.

Signature

> Sorry I did not make this clear. I installed SQL Enterprise on the
> cluster. There is only one instance.
>
> In the Server 2003 Event log, there is only a indication that the MS
> SQL Agent Service Stopped at so-and-so time. It's not a fatal warning,
> or anything. It does not restart itself.

Reply to this Message

Anthony Thomas - 26 Jan 2006 03:01 GMT

Not to mention that by default, if the SQL Agent shuts down, it will cause
an instance failover. If it doesn't fail over, then it is not set up to
affect the group, or someone marked set it offline manually.

Try posting the SQL Agent log and SQL Server error log.

Sincerely,

Anthony Thomas

> There is a message that it stopped. WHY did it stop? Was it a request to
> stop, did it abort, etc. There is never just one message. It either shut
[quoted text clipped - 9 lines]
> > SQL Agent Service Stopped at so-and-so time. It's not a fatal warning,
> > or anything. It does not restart itself.

Reply to this Message