X-Received: by 10.236.4.69 with SMTP id 45mr29248795yhi.20.1381156940667; Mon, 07 Oct 2013 07:42:20 -0700 (PDT) X-Received: by 10.50.11.16 with SMTP id m16mr654512igb.0.1381156940589; Mon, 07 Oct 2013 07:42:20 -0700 (PDT) Path: news.cambrium.nl!textnews.cambrium.nl!feeder1.cambriumusenet.nl!feed.tweaknews.nl!209.197.12.246.MISMATCH!nx02.iad01.newshosting.com!newshosting.com!news-out.readnews.com!news-xxxfer.readnews.com!209.85.216.87.MISMATCH!a6no6227717qak.0!news-out.google.com!9ni20631qaf.0!nntp.google.com!i2no2138732qav.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail Newsgroups: comp.databases.oracle.server Date: Mon, 7 Oct 2013 07:42:20 -0700 (PDT) Complaints-To: groups-abuse@google.com Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=65.124.128.20; posting-account=1htiWwoAAACwl9Y0yZoYWxAtY2AaBdd- NNTP-Posting-Host: 65.124.128.20 User-Agent: G2/1.0 MIME-Version: 1.0 Message-ID: <441c930b-c642-4192-95a3-bc8db66a0e2c@googlegroups.com> Subject: Send email when Invalid_Logon_Count=5 From: JN Injection-Date: Mon, 07 Oct 2013 14:42:20 +0000 Content-Type: text/plain; charset=windows-1252 Content-Transfer-Encoding: quoted-printable Xref: news.cambrium.nl What is the best best way to send an email if a certain table gets to the n= umber 5. Any thoughts would be greatly appreciated. Below is the query I run to check on the Dex account: It=92s the Invalid_Lo= gon_Count that holds the 0-6 value I=92m looking for. 0 is good and 6 is lo= cked out. Use CABINET select name, Invalid_Logon_Count, userinstanceid from USERS (no= lock) where NAME =3D 'dex'