Database Scripts

Beta
 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.

Versions

SQL Server 2008 and up.

DOWNLOAD

Script is a zip file and only available for download.

Report Script

blog comments powered by Disqus