Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

SQL/PL SQL - Count rows from table and send email if count > 0

kmapes-JavaNetApr 5 2011 — edited Apr 5 2011
I am running 11.1.0.7 on a Windows platform. I want to have a SQL/PL SQL job I can schedule that will go out and look through a table and if it finds any rows with a status of 'ERROR' then send an email out.

I have the SQL that will select (*) from <table> where STATUSSTRING = 'ERROR', how do I get it to then send an email out? I do have an SMTP server accessible to the server on which this script will run.


Thanks in advance for your help.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on May 3 2011
Added on Apr 5 2011
#pl-sql, #plsql, #sqlplus, #windows
1 comment
346 views