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

Hi

How about NET STOP?

John

"Spin" <Spin@invalid.com> wrote in message
news:656t5iF2eq3dbU1@mid.individual.net...
> 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
>

"John Bell" <jbellnewsposts@hotmail.com> wrote in message
news:e2yjJedkIHA.5368@TK2MSFTNGP04.phx.gbl...
> 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.

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

"Spin" wrote:

> 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
>
>
>

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

"Linchi Shea" <LinchiShea@discussions.microsoft.com> wrote in message
news:C9EF5727-A88B-4261-B445-266B2C45990C@microsoft.com...
> 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
>
> "Spin" wrote:
>
>> 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
>>
>>
>>

"Linchi Shea" <LinchiShea@discussions.microsoft.com> wrote in message
news:C9EF5727-A88B-4261-B445-266B2C45990C@microsoft.com...
> 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

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

--
Spin