Or you can use it in your further T-SQL development where replication state plays major role. What is prepared for you is using this procedure in SQL Agent job informing you where there is some ...

SQL Server Replication Monitoring Simple solution for regular checking of replication subscriptions based on querying system tables on distribution server. Require Database Mail to notify you ...