On several occasions we have had a database unexpectedly go into a recovering state. The instance was still available, and no issues were shown on the monitoring, SQL or Insight.

I was not immediately able to find a way to alert on database state.

Is there any way to alert when a database is in offline, recovering, restoring, etc status? Specifically, if a DB is offline for more than 10 polls, or is recovering for more than 10 polls, as an example.

It would be nice if this were a global setting on the monitor, but the alert could be skipped on specific databases.