July 7, 2003 at 7:30 am
Folks,
Rebooted a cluster node last week. SQLAgent shows as online, but later we found out that it is offline and jobs are not being executed.
An ideas why cluster admin would still show it as online?
Cheers
July 7, 2003 at 10:35 am
Make sure your sql server agent is a dependent on SQL Server
Shas3
July 7, 2003 at 5:34 pm
That would be my first place to look check all your cluster dependencies and make sure they are all tied to the right groups.
Wes
July 8, 2003 at 1:30 am
Folks,
SQLAgent is dependent on SQL Server on that node.
July 8, 2003 at 5:49 am
the cluster admin saw it as online but did it appear to be running in ether enterprise manager or the service manager?
Wes
July 11, 2003 at 3:43 am
It appeared to be running in the service manager. But in EM it had stopped and all jobs were failing. What brought our attention to it is that a transaction log started getting bigger than usual.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply