1 Reply Latest reply: Aug 27, 2004 3:48 AM by 136780 RSS

    user defined sql test event


      I have created an event that runs the query
      select count(*)
      from dl.batch_error_log
      where trunc(timestamp) = trunc(sysdate)
      and status = 'Failed'

      I have set the critical and warning threshold >= 1
      and occurences preceding notification = 1.
      It is scheduled on interval, immediately after registration, every 5 minutes.
      When I run the quere as an job it works and return two rows, but the event never trigger an alert.
      I have looked in the view sysman.smp_view_event_status and my event have event_status = 205 as all my other
      "predefined" events, like DB UpDown that works.

      Running OEM version and Oracle

      Happy for any suggestion.

      Ulf M