Agent job availability (rollup)

Microsoft.SQLServer.2016.Agent.AgentJobAvailabilityRollup (DependencyMonitor)

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.

Knowledge Base article:

Summary

This monitor rolls up the availability state from SQL Agent Jobs to SQL Agent.

Overridable Parameters

Name	Description	Default Value
Enabled	Enables or disables the workflow.	Yes
Generates Alerts	Defines whether the workflow generates an Alert.	No

Element properties:

Target	Microsoft.SQLServer.2016.Agent
Parent Monitor	System.Health.AvailabilityState
Algorithm	WorstOf
Source Monitor	System.Health.AvailabilityState
Relationship	Microsoft.SQLServer.2016.AgentHostsAgentJob
Category	AvailabilityHealth
Enabled	True
Alert Generate	False
Alert Auto Resolve	True
Remotable	True
Accessibility	Public

Source Code:

<DependencyMonitor ID="Microsoft.SQLServer.2016.Agent.AgentJobAvailabilityRollup" Accessibility="Public" Enabled="true" Target="SQL2016Core!Microsoft.SQLServer.2016.Agent" ParentMonitorID="SystemHealth!System.Health.AvailabilityState" Remotable="true" Priority="Normal" RelationshipType="SQL2016Core!Microsoft.SQLServer.2016.AgentHostsAgentJob" MemberMonitor="SystemHealth!System.Health.AvailabilityState">

  <Category>AvailabilityHealth</Category>

  <Algorithm>WorstOf</Algorithm>

  <MemberUnAvailable>Error</MemberUnAvailable>

</DependencyMonitor>