dbTalk Databases Forums  

SQL Server Agent stops on SQL Cluster.

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


Discuss SQL Server Agent stops on SQL Cluster. in the microsoft.public.sqlserver.clustering forum.



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

Default SQL Server Agent stops on SQL Cluster. - 07-12-2004 , 06:00 AM






Hi everyone,

We have Active/Passive Windows 2003 Cluster, running Virtual SQL Server instance. Occasionally we see that the SQL Server Agent Service on the Active node has stopped. We rely on the SQL Server Agent Service to back up our database transaction log every 30 minutes. Is there any way of automatically monitoring the SQL Server Agent Service and notifying a predefined person/computer that it is not running. Basically, I want to get notified when neither of the nodes has a SQL Server Agent Service running(both stopped),because I can't know which node is active without checking.

Best regards.

Sezgin Rafed


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.