Check for Undistributed Commands

07 Aug 2019 0 minutes to read Contributors

Situation

When you have replication implemented you need to check for problems in delivering data to the subscribers. In case the data cannot be delivered to a subscriber due to many different reasons, the undistributed commands will accumulate. 

Checking for the amount of undistributed commands, gives you a heads up on that.

Solution

Below procedure and function can be implemented on the distribution server. You can schedule this procedure in a job every five minutes and it will send out a mail informing you of the situation.

 

In this article