Skip to main content
How can we help?
< All Topics
Print

Agent job differences

An alert will be thrown, if two SQL Servers are a failover pair, and there are differences in the SQL Server Agent jobs between the two servers.

To query the Performance Store database for agent job differences, use:

exec dbo.s_agent_job_diff '[server 1]', '[server 2]'

A script for synchronizing agent jobs between a primary and secondary can automatically be created. See Synchronize Availability Group objects for more information.

It is also possible to use the Database Finder to quickly identify agent job differences, or to verify the integrity between two failover nodes. For more information see: Integrity between failover nodes.

The alert will be visible on the Latest stats dashboard.

To exclude specific servers from this alert, see how to use the dbo.team_alert_exclude table in Alerting.

Table of Contents