Home
  •  

Agent job performance (rollup)

Microsoft.SQLServer.2012.Agent.AgentJobPerformanceRollup (DependencyMonitor)

This monitor rolls up performance 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 overall performance health for the agent job.

Overrideable Parameters

Name

Description

Default Value

Enabled

Enables or disables the workflow.

Yes

Generates Alerts

Defines whether the workflow generates an Alert.

No

Element properties:

TargetMicrosoft.SQLServer.2012.Agent
Parent MonitorSystem.Health.PerformanceState
AlgorithmWorstOf
Source MonitorSystem.Health.PerformanceState
RelationshipMicrosoft.SQLServer.2012.AgentHostsAgentJob
CategoryPerformanceHealth
EnabledTrue
Alert GenerateFalse
Alert Auto ResolveFalse
RemotableTrue
AccessibilityPublic

Source Code:

<DependencyMonitor ID="Microsoft.SQLServer.2012.Agent.AgentJobPerformanceRollup" Accessibility="Public" Enabled="true" Target="SQL2012Core!Microsoft.SQLServer.2012.Agent" ParentMonitorID="SystemHealth!System.Health.PerformanceState" Remotable="true" Priority="Normal" RelationshipType="SQL2012Core!Microsoft.SQLServer.2012.AgentHostsAgentJob" MemberMonitor="SystemHealth!System.Health.PerformanceState">

  <Category>PerformanceHealth</Category>

  <Algorithm>WorstOf</Algorithm>

  <MemberUnAvailable>Error</MemberUnAvailable>

</DependencyMonitor>