dbTalk Databases Forums  

sql server agent - online pending status

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering


Discuss sql server agent - online pending status in the microsoft.public.sqlserver.clustering forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Sonia
 
Posts: n/a

Default sql server agent - online pending status - 09-18-2008 , 04:21 PM






My 2 -node sql clusters (active/passive) rebooted today because of power
failure. When they came up SQL server agent is showing online pending status
when I check it from cluster admin. I restarted the server again one at a
time thinking that may be there was some resource conflict but that did not
help. When I check sql server agent service on the active node through
service manager, Its showing STARTED. Is there anything I could try? I am not
sure if it will affect the clutser in the long run and put the sql server
service offline.

I will appreciate any input.

Reply With Quote
  #2  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: sql server agent - online pending status - 09-18-2008 , 08:31 PM






Are you able to actually run any SQL agent jobs?

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP


"Sonia" <Sonia (AT) discussions (DOT) microsoft.com> wrote

Quote:
My 2 -node sql clusters (active/passive) rebooted today because of power
failure. When they came up SQL server agent is showing online pending
status
when I check it from cluster admin. I restarted the server again one at a
time thinking that may be there was some resource conflict but that did
not
help. When I check sql server agent service on the active node through
service manager, Its showing STARTED. Is there anything I could try? I am
not
sure if it will affect the clutser in the long run and put the sql server
service offline.

I will appreciate any input.


Reply With Quote
  #3  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: sql server agent - online pending status - 09-18-2008 , 08:31 PM



Are you able to actually run any SQL agent jobs?

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP


"Sonia" <Sonia (AT) discussions (DOT) microsoft.com> wrote

Quote:
My 2 -node sql clusters (active/passive) rebooted today because of power
failure. When they came up SQL server agent is showing online pending
status
when I check it from cluster admin. I restarted the server again one at a
time thinking that may be there was some resource conflict but that did
not
help. When I check sql server agent service on the active node through
service manager, Its showing STARTED. Is there anything I could try? I am
not
sure if it will affect the clutser in the long run and put the sql server
service offline.

I will appreciate any input.


Reply With Quote
  #4  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: sql server agent - online pending status - 09-18-2008 , 08:31 PM



Are you able to actually run any SQL agent jobs?

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP


"Sonia" <Sonia (AT) discussions (DOT) microsoft.com> wrote

Quote:
My 2 -node sql clusters (active/passive) rebooted today because of power
failure. When they came up SQL server agent is showing online pending
status
when I check it from cluster admin. I restarted the server again one at a
time thinking that may be there was some resource conflict but that did
not
help. When I check sql server agent service on the active node through
service manager, Its showing STARTED. Is there anything I could try? I am
not
sure if it will affect the clutser in the long run and put the sql server
service offline.

I will appreciate any input.


Reply With Quote
  #5  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: sql server agent - online pending status - 09-18-2008 , 08:31 PM



Are you able to actually run any SQL agent jobs?

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP


"Sonia" <Sonia (AT) discussions (DOT) microsoft.com> wrote

Quote:
My 2 -node sql clusters (active/passive) rebooted today because of power
failure. When they came up SQL server agent is showing online pending
status
when I check it from cluster admin. I restarted the server again one at a
time thinking that may be there was some resource conflict but that did
not
help. When I check sql server agent service on the active node through
service manager, Its showing STARTED. Is there anything I could try? I am
not
sure if it will affect the clutser in the long run and put the sql server
service offline.

I will appreciate any input.


Reply With Quote
  #6  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: sql server agent - online pending status - 09-18-2008 , 08:31 PM



Are you able to actually run any SQL agent jobs?

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP


"Sonia" <Sonia (AT) discussions (DOT) microsoft.com> wrote

Quote:
My 2 -node sql clusters (active/passive) rebooted today because of power
failure. When they came up SQL server agent is showing online pending
status
when I check it from cluster admin. I restarted the server again one at a
time thinking that may be there was some resource conflict but that did
not
help. When I check sql server agent service on the active node through
service manager, Its showing STARTED. Is there anything I could try? I am
not
sure if it will affect the clutser in the long run and put the sql server
service offline.

I will appreciate any input.


Reply With Quote
  #7  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: sql server agent - online pending status - 09-18-2008 , 08:31 PM



Are you able to actually run any SQL agent jobs?

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP


"Sonia" <Sonia (AT) discussions (DOT) microsoft.com> wrote

Quote:
My 2 -node sql clusters (active/passive) rebooted today because of power
failure. When they came up SQL server agent is showing online pending
status
when I check it from cluster admin. I restarted the server again one at a
time thinking that may be there was some resource conflict but that did
not
help. When I check sql server agent service on the active node through
service manager, Its showing STARTED. Is there anything I could try? I am
not
sure if it will affect the clutser in the long run and put the sql server
service offline.

I will appreciate any input.


Reply With Quote
  #8  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: sql server agent - online pending status - 09-18-2008 , 08:31 PM



Are you able to actually run any SQL agent jobs?

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP


"Sonia" <Sonia (AT) discussions (DOT) microsoft.com> wrote

Quote:
My 2 -node sql clusters (active/passive) rebooted today because of power
failure. When they came up SQL server agent is showing online pending
status
when I check it from cluster admin. I restarted the server again one at a
time thinking that may be there was some resource conflict but that did
not
help. When I check sql server agent service on the active node through
service manager, Its showing STARTED. Is there anything I could try? I am
not
sure if it will affect the clutser in the long run and put the sql server
service offline.

I will appreciate any input.


Reply With Quote
  #9  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: sql server agent - online pending status - 09-18-2008 , 08:31 PM



Are you able to actually run any SQL agent jobs?

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP


"Sonia" <Sonia (AT) discussions (DOT) microsoft.com> wrote

Quote:
My 2 -node sql clusters (active/passive) rebooted today because of power
failure. When they came up SQL server agent is showing online pending
status
when I check it from cluster admin. I restarted the server again one at a
time thinking that may be there was some resource conflict but that did
not
help. When I check sql server agent service on the active node through
service manager, Its showing STARTED. Is there anything I could try? I am
not
sure if it will affect the clutser in the long run and put the sql server
service offline.

I will appreciate any input.


Reply With Quote
  #10  
Old   
Geoff N. Hiten
 
Posts: n/a

Default Re: sql server agent - online pending status - 09-18-2008 , 08:31 PM



Are you able to actually run any SQL agent jobs?

--
Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP


"Sonia" <Sonia (AT) discussions (DOT) microsoft.com> wrote

Quote:
My 2 -node sql clusters (active/passive) rebooted today because of power
failure. When they came up SQL server agent is showing online pending
status
when I check it from cluster admin. I restarted the server again one at a
time thinking that may be there was some resource conflict but that did
not
help. When I check sql server agent service on the active node through
service manager, Its showing STARTED. Is there anything I could try? I am
not
sure if it will affect the clutser in the long run and put the sql server
service offline.

I will appreciate any input.


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.