RE: Emailing Query Results?
- From: DENNIS WILLIAMS <DWILLIAMS@xxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 27 Oct 2004 11:20:34 -0500
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@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
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@xxxxxxxxxxxxx
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
