This monitor rolls up the availability state from SQL Agent Jobs to SQL Agent.
Note that SQL Server Agent Windows Service is not supported by any edition of SQL Server Express; there is no appropriate discovered object.
This monitor rolls up the availability state from SQL Agent Jobs to SQL Agent.
Name | Description | Default Value |
Enabled | Enables or disables the workflow. | Yes |
Generates Alerts | Defines whether the workflow generates an Alert. | No |
Target | Microsoft.SQLServer.2014.Agent |
Parent Monitor | System.Health.AvailabilityState |
Algorithm | WorstOf |
Source Monitor | System.Health.AvailabilityState |
Relationship | Microsoft.SQLServer.2014.AgentHostsAgentJob |
Category | AvailabilityHealth |
Enabled | True |
Alert Generate | False |
Alert Auto Resolve | True |
Remotable | True |
Accessibility | Public |
<DependencyMonitor ID="Microsoft.SQLServer.2014.Agent.AgentJobAvailabilityRollup" Accessibility="Public" Enabled="true" Target="SQL2014Core!Microsoft.SQLServer.2014.Agent" ParentMonitorID="SystemHealth!System.Health.AvailabilityState" Remotable="true" Priority="Normal" RelationshipType="SQL2014Core!Microsoft.SQLServer.2014.AgentHostsAgentJob" MemberMonitor="SystemHealth!System.Health.AvailabilityState">
<Category>AvailabilityHealth</Category>
<Algorithm>WorstOf</Algorithm>
<MemberUnAvailable>Error</MemberUnAvailable>
</DependencyMonitor>