Why is the SQL Server Agent Status rule defined to only fire when the start mode is automatic?
In Cluster servers the "SQL Server Agent" service may be set to "Manual" and the rule condition for "DBSS - SQL Server Agent Status" will evaluate the following:
registry("DBSS-ServicesSQLServerAgentStatus_High")) && mode == 1;
Automatic is mode 1, Manual is mode 2.
The "DBSS_Service_Start_Mode_Enum" property values are (name , value , index):
If the service is on manual, it may not need to be up so there may not be a need for any alarm.
The rule can be customized.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center