How do I create an alert on DPA to alert of the SQL server service was restarted or server rebooted?
I have setup the administrative alert (Windows service not running) with a 10 min frequency, but if the service was restarted and not down for 10 min, then I don't get an alert. I would like to know anytime the service was restarted (regardless of how long it was down).
Thanks.
