Creating a Rule to Notify Different Administrators Based on the Event Type

As per operations policy for production databases, the incidents that relate to application issues should go to the application DBAs and the incidents that relate to system parameters should go to the system DBAs. Accordingly, the respective incidents will be assigned to the appropriate DBAs and they should be notified by way of email.

Before you set up rules, ensure the following prerequisites are met:

  • DBA has setup appropriate thresholds for the metric so that critical metric alert is generated as expected.

  • Rule has been setup to create incident for all such events.

  • Respective notification setup is complete, for example, global SMTP gateway, email address, and schedule for individual DBAs.

Perform the following steps:

  1. Navigate to the Incident Rules page.

    From the Setup menu, select Incidents, then select Incident Rules.

  2. Search the list of enterprise rules matching the events from the production database.
  3. On the Incident Rules - All Enterprise Rules page, highlight a rule set and click Edit....

    Rules are created in the context of a rule set. If there is no existing rule set, create a rule set.

  4. From the Edit Rule Set page (Rules tab), select the rule which creates the incidents for the metric alert events for the database. Click Edit
  5. From the Select Events page, click Next.
  6. From the Add Actions page, click +Add. The Add Conditional Actions page displays.
  7. In the Notifications area, enter the email address of the DBA you want to be notified for this specific event type and click Continue to add the action. Enterprise Manager returns you to the Add Actions page. Click Next.
  8. On the Specify Name and Description page, enter an intuitive rule name and a brief description.
  9. Click Next.
  10. On the Review page, review the Applies to, Actions and General information for correctness .
  11. Click Continue to create the rule.
  12. Create/Edit additional rules to handle alternate additional administrator notifications according to event type.
  13. Review the rules summary and make corrections as needed. Click Save to save your rule set changes.