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.
blog comments powered by Disqus