Is there a Cluster command line I can run which will stop my "SQL Agent Service"?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Spin - 29 Mar 2008 14:05 GMT

Gurus,

Running SQL Server 2005 SP2 on a Windows Server 2003 Cluster. Is there a
Cluster command line I can run which will stop my "SQL Agent Service"?

--
Spin

Reply to this Message

John Bell - 29 Mar 2008 21:00 GMT

Hi

How about NET STOP?

John

> Gurus,
>
[quoted text clipped - 3 lines]
> --
> Spin

Reply to this Message

Spin - 29 Mar 2008 22:54 GMT

> Hi
>
> How about NET STOP?

No can do John. NET STOP stops the service outside of the Cluster
environment. What will happen is the Windows Cluster service will detect
the service down then automatically restart it! What I need is a Cluster
service command line tool which gracefully stops the service per "knowledge"
if you will, of the Cluster service.

Reply to this Message

Linchi Shea - 30 Mar 2008 01:37 GMT

For the default instance:

cluster.exe /cluster:<cluster name> resource "SQL Server Agent" /offline

For a named instance (assuming that the instance name is SQL2):

cluster.exe /cluster:<cluster name> resource "SQL Server Agent (SQL2)"
/offline

Linchi

> Gurus,
>
[quoted text clipped - 3 lines]
> --
> Spin

Reply to this Message

Spin - 30 Mar 2008 06:15 GMT

Thanks! I'll shout back on Monday if this works...

> For the default instance:
>
[quoted text clipped - 14 lines]
>> --
>> Spin

Reply to this Message

Spin - 31 Mar 2008 15:23 GMT

> For the default instance:
>
[quoted text clipped - 6 lines]
>
> Linchi

Worked!!!!! You are a Gentleman and a Scholar!

--
Spin

Reply to this Message