Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Emailing Query Results?

RE: Emailing Query Results?

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Wed, 27 Oct 2004 11:20:34 -0500
Message-ID: <6BA0194B4809D9118361000F1F6C9510017E1B33@exchmn4.lifetouch.com>


Here is an article on how to do it within Oracle. I think someone on this list has this working. Has anyone got this working on W2K?

http://www.databasejournal.com/features/oracle/article.php/1496631

Dennis Williams
DBA
Lifetouch, Inc.

-----Original Message-----

From: DENNIS WILLIAMS
Sent: Wednesday, October 27, 2004 11:18 AM To: oracle-l_at_freelists.org
Subject: RE: Emailing Query Results?

Michael

   You didn't mention the platform. I can't answer for Oracle jobs. On Unix, I do have a korn shell script executed by cron that fires up sqlplus, runs a query, sends the output to a file, then exits sqlplus and emails the file.

Dennis Williams
DBA
Lifetouch, Inc.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Michael Cupp, Jr.
Sent: Wednesday, October 27, 2004 10:11 AM To: Oracle-L
Subject: Emailing Query Results?

I would like to create a query that runs nightly (maybe a procedure, kicked off from oracle jobs?) that runs a query, and if the query results in rows returned, then to have it email to a specified email account(s). Think exception list - for example, select customer_no, customer_name, city, state from customers where customer_zip_code is null or length(customer_zip_code) not in (5,10); - This way we can tackle nightly issues that arrise before they become a large issue. (I KNOW I KNOW - require the field - Our specific example isn't based on ZIP CODE, so I can't for other reasons)

Has anyone done this? Can anyone give me examples?

Thanks,
M



Michael Cupp, Jr.
Perma-Fix Industrial Services
mcupp_at_perma-fix.com

--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Wed Oct 27 2004 - 11:17:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US