9i OEM event not triggering

[smd]

ok 2 questions in one day.

We have set our default profile to lock accounts after 10 failed logins. and I set up an even that runs every 5 min in 9i oem that does a user defined sql test

SELECT COUNT(*)
FROM dba_users
WHERE account_status = 'LOCKED(TIMED)'

operator is >= 1

i then force an account to lockout after 10 failed attempts but it never triggers the event? Any ideas?

Regards,
SMD

[jay_l_a]

>>and I set up an even that runs every 5 min in 9i oem that does a user defined sql test

How are you doing this? DBMS_JOB?

I'm assuming that you're trying to generate some auto-notification about this event, right?

>>but it never triggers the event

Are you saying the account never gets locked after ten failed attempts, or you don't receive the notification?
J