Re: Send email when Invalid_Logon_Count=5

On Monday, October 7, 2013 7:42:20 AM UTC-7, JN wrote:
> 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'

Is this an Oracle database?

jg

-- 
_at_home.com is bogus.
http://www.techrepublic.com/blog/tech-decision-maker/oracles-licensing-rules-five-common-pitfalls-to-watch-out-for/