Oh the irony of it all !!
In my previous post I mentioned what I see as a fatal flaw with the “Alert on Error” scenario, well no sooner posted than to quote Shakespeare “hoisted by my own petard”
HA! I have a log shipped setup where the server communicates alerts using smtp .. well today I discovered that for some reason or another any alerts were not reaching me as it appears there is an issue raising them, no errors on the servers just no emails arriving.
In my defence I have a visual display which shows the latency of the log shipped databases along with a list of the restored files, parts of the display change colour according to how far behind production the log shipped databases are, so I knew all was well, a failure of the display is also an indication of an issue, e.g. a network link down for example.
SO .. there you have it a full working example on the dangers of only alerting on an error.