Database Query Monitor Oracle database

Database Query Monitor Oracle database

Hello

I am trying to add a database query monitor that will check the status of the triggers of the database and sends a critical alert when any of them is disabled.
The query I am running is
select status from dba_triggers where OWNER not like '%SYS%' and STATUS='DISABLED'
I have set "status" as a primary key, though I do not know how I can set an alarm when status is disabled.
Could you kindly let me know how I could possibly define such a metric?

Thank you.

St.
              New to ADManager Plus?

                New to ADSelfService Plus?