I am trying to setup replication monitoring between my servers so that i get notified if any db has not replicated in a specified interval.
Now, my problem is if db A has not replicated with another server due to no updates made to the db, it will still notify me. Not only that.. it notifies me repeatedly. I m not sure what suppression time or threshhold value are meant for ??.... i thought it was meant to suppress another message once a notice is sent ? could you clarify if you know what is the best way to suppress repeated notification for the same event?
Other option i might consider in future is to write an agent that keeps updating a minor (non critical) doc in the db.. but it won't happen in distant future ... i know it is very simple code to write in prd db but my mgmt in this strictly controlled env has to go thru all kinds of approval.
In the mean time i m trying to explore other possibility like writing an external agent which could check the replication history and then checks for writes (in the activity log) before it sends notice out to inform that replication is not happening.