This discussion is archived
1 Reply Latest reply: Aug 27, 2004 1:48 AM by 136780 RSS

user defined sql test event

136780 Newbie
Currently Being Moderated
Hi,

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 9.2.0.1.0 and Oracle 9.2.0.5.

Happy for any suggestion.

Regards
Ulf M