Miscellaneous Agents

SQL Replication

Replication

Miscellaneous Agents

The Miscellaneous Agents folder in Replication Monitor lists the agents needed to clean up and monitor different replication processes.

Agent History Clean Up Agent

The Agent History Clean Up Agent removes replication agent history from the distribution database. This agent runs every 10 minutes by default. Running this agent is helpful in managing the size of the distribution database.

Distribution Clean Up Agent

The Distribution Clean Up Agent removed replicated transactions from the distribution database. This agent runs for snapshot and transactional publications every 72 hours by default. The Distribution Clean Up Agent may deactivate a subscription if the subscription has not been synchronized within the maximum distribution retention period. For more information, see Subscription Deactivation and Expiration.

Expired Subscription Clean Up Agent

Detects and removes expired subscriptions from the published databases. If a subscription is deactivated, the subscription will be removed by the Expired Subscription Clean Up Agent, which runs once a day by default. A subscription is marked as expired either during the cleanup process or when the replication agent runs after the publication retention period has been exceeded. For more information, see Subscription Deactivation and Expiration.

Reinitialize Subscriptions Having Data Validation Failures Agent

Reinitializes all subscriptions that have data validation failures. This agent is not set on a schedule by default. Run this agent to automatically detect the subscriptions that failed validation and mark them for reinitialization. After the subscriptions are marked for reinitialization, the next time the Merge Agent or Distribution Agent runs, a new snapshot will be applied at the Subscribers.

Replication Agents Checkup Agent

Detects replication agents that are not actively logging history. This agent runs every 10 minutes by default, and it writes to the Windows event log if the job step fails. 

See Also

Anonymous Subscriptions

Planning for Transactional Replication

Subscription Deactivation and Expiration