I have created an event that runs the query
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.