Create Subscription for Alerts with specific Alert context RRS feed

  • Question

  • Hi

    I have the problem, that we have some DBs, that are always offline. Offline isn't an "Error" for us.

    The SQL MP has the Monitor "Database Status", which checks if the db status is offline, recovery pending,suspect or emergency.

    We only want some alerts, when the DB is suspect or emegency. unfortunately I found no way to override the Monitor, that it only alert this two stats. 

    So I had the idea, to send an SMS/Email only, when in the "Alert Context" the "DatabaseState" is suspect or emergency. But in the subscription settings, I can only filter for "with specific text in the description". Is there a way to filter for the Alert Context?

    Or is there another way to solve this problem?

    Kind Regards

    Friday, April 3, 2020 6:31 AM

All replies