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

Only thing you have to do is to copy deplyment script. Open it in SQL Server Management Studio and run it against SQL Server instance you are connected to or use multiquery from Registered Servers.