Enterprise Manager -- Clear warnings appearing on dashboard..

Sometimes, Enterprise Manager alerts can be annoying... Fixing the problems that generate these alerts , actually does not clear these alerts...

Here is the way to clear these events from backend...

Run the following query and execute the output of the query with sysman..

select  'exec em_severity.delete_current_severity(''' ||
t.target_guid || ''',''' ||
metric_guid || ''',''' ||
key_value || ''')' em_severity
from sysman.mgmt_targets t
inner join
sysman.mgmt_current_severity s
on
t.target_guid = s.target_guid;

For example:

exec sysman.em_severity.delete_current_severity('....','....','.....','.....')..