Database Scripts

 Log In    |   Sign Up

SQL Server : Monitor SQL Server Replication Jobs

Added on Dec-11-2011 by admin
For SQL Server

Tags : monitoringreplication

This set contains three scripts. MonitorEnableReplicationAgents.sql checks that key components in the replication are enabled (and enables them if there are disabled) so they can be search for by their Category. MonitorReplicationAgentsSchedules.sql checks that replication agents any additional required schedules and create the schedule if it is missing. MonitorSnapshotAgentsSchedules.sql checks that Snapshot agents do not have a schedule and deletes the schedule if it exists. To use these scripts first run the scripts to create the stored procedures, then create a job that executes the stored procedures every hour.


SQL Server 2008 and up.


Script is a zip file and only available for download.

Report Script

blog comments powered by Disqus