Clearing Alerts

SELECT 'execute em_severity.delete_current_severity(p_target_guid =>'''||sev.target_guid||''', p_metric_guid =>'''||sev.metric_guid||'''
       , p_key_value =>'''||key_value||''');' AS command
  FROM MGMT_TARGETS tgt
     , MGMT_CURRENT_SEVERITY sev
 WHERE tgt.TARGET_NAME like '%&TGT_NAME%';

For older severities, just a straight delete from MGMT_SEVERITY table will do the trick!