I am having the same trouble with getting the "Replication Warning: Subscription expiration" alert to work.
It does not alert before the subscription is marked expired and needs to be reintialized.
Does anyone know how to configure that alert so that it works if the default: SQL Server event Alert\14160 is not what makes the alert fire.
And possibly an easy way to test it.
As I try to trouble shoot I found a table MSpublicationthresholds that has a column:
shouldalert: A value of 1 indicates that an alert should be generated when the metric exceeds the defined threshold.
I cannot figure how to set that value other than directly update the table.
Note replication monitor interface has an enable check box that affects this field:
isenabled: A value of 1 indicates that monitoring is enabled for this replication performance metric.
It is as though you can't turn shouldalert on via the GUI.
Even if I do manually change it or with the proc below, there is still the question about having to reconfigure the default alert to get it to work?
There is the proc that the replmon uses to change the isenabled value:
View Complete Post