We would like to have an alert trigger when Polling Completion for a poller drops below 99%. We have 3 pollers. Is this possible? We're running 9.1. SP5
Hi,
The Advanced or Basic alerts do not allow you to trigger alerts based on these properties.
I would look at the possibility of using either Triggers or Stored Procedures or both to monitor critical information like the polling completion when this is not possible to do it with Advanced and Basic alerts.
This is not supported so do it at your own risks. I have not tested it here.
You could setup a Trigger on updates of the Engines table that uses the xp_sendmail stored procedure whenever the Polling Completion drops under 99% so that you receive an email with SQL statistics + values from the tables.
Thanks,
Yann