As an example, let's say you want to be notified whenever a certain schema has any invalid objects in it. This is how to setup such an alert:
- Navigate to the database instance "Home" page
- Click the "User Defined Metrics" link at the bottom of the page
- Click the "Create" button to create a new UDM
- Complete all of the form fields
- SQL query you would like to run (don't use a semi-colon at the end!)
- Credentials
- Thresholds
- Schedule
- Note that you can customize the subject line of the notification emails
- Click the "Test" button to make sure the results are what you want
- Click "Ok" to save this UDM
- Now, if you merely stop here, no notifications will ever be sent! Why? Because there is no Notification Rule defined, so let' s do that next...
- Click "Preferences" in the top right corner of any Grid Control page
- Click "Rules" in the left nav bar
- Create a new Notification Rule
- Voila! Now email notifications will be sent whenever your threshold is exceeded and the this metric automatically integrates with all of the Alert display boxes throughout OEM.
5 comments:
hey any idea how to run plsqlprocedure in UDM. I can just see SQL's here
sandarsh: I have not yet tried using PL/SQL in a UDM...
Did you try just using a BEGIN/END block as seeing what was returned? Seems to me that there has to be some way to do it :)
One important detail: You mentioned "You can modify subject line on the alert email" ,
i am not sure about that, the "message" field is for the message body. Please let me know if it is possible
Hi Beent, You mentioned that "Note that you can customize the subject line of the notification emails", can you please let me know how?
The subject line is customized by entering the text into the "Alert Message" on the "Edit Used-Defined Metric" page.
Note: In the new OEM 11g, you can customize the body as well!
Post a Comment