Query to Find Oracle Alerts

The following query finds all enabled custom alerts. You can comment out the very last two lines (enabled_flag and created_by) to display all both enabled and disabled alerts.



SELECT created_by,
  enabled_flag,
  application_id,
  alert_id,
  alert_name,
  start_date_active,
  description,
  sql_statement_text
FROM apps.alr_alerts
WHERE 1          =1
AND created_by  <> 1   -- Shows only custom alerts
AND enabled_flag = 'Y';-- Shows only enabled alerts