sp_replication_agent_checkup (T-SQL)

Checks each distribution database for replication agents that are running but have not logged history within the specified heartbeat interval.

Syntax

sp_replication_agent_checkup [[@heartbeat_interval =] heartbeat_interval]

Arguments

[@heartbeat_interval =] 'heartbeat_interval'

Is the maximum number of minutes that an agent can go without logging a progress message. heartbeat_interval is int, with a default of 10 minutes.

Return Code Values

sp_replication_agent_checkup raises error 14151 for each agent it detects as suspect. It also logs a failure history message about the agents.

Remarks

sp_replication_agent_checkup is used in snapshot, transactional, and merge replication.

Permissions

Only members of the sysadmin fixed server role can execute sp_replication_agent_checkup.

See Also