Send email when Invalid_Logon_Count=5

[JN]

What is the best best way to send an email if a certain table gets to the number 5.

Any thoughts would be greatly appreciated.

Below is the query I run to check on the Dex account: It’s the Invalid_Logon_Count that holds the 0-6 value I’m looking for. 0 is good and 6 is locked out.

Use CABINET select name, Invalid_Logon_Count, userinstanceid from USERS (nolock) where NAME = 'dex'

[jaycosmo]

Could you give more details on the environment? Is it notifications you need help with?  If so, look into writing a watchdog script to send you an email with your condition as a trigger. 

-yaw

--
You received this message because you are subscribed to the Google Groups "ORACLE_DBA_EXPERTS" group.
To unsubscribe from this group and stop receiving emails from it, send an email to oracle_dba_expe...@googlegroups.com.
To post to this group, send email to oracle_db...@googlegroups.com.
Visit this group at http://groups.google.com/group/oracle_dba_experts.
For more options, visit https://groups.google.com/groups/opt_out.

[ddf]

Which release of Oracle are you running?

 

 

David Fitzjarrell 

[JN]

Oracle DB 10.2.6

Yes what I am looking for is when the value in this row gets to 5 I would like an email so I can log in and clear the entry versus it getting locked out and then getting paged.  I would like to be preemptive about the lockout.