>I am having difficulty getting the output from the SQL script to e-mail
from CRON. Any suggestions would be greatly
>appreciated.

How are you issuing the command in cron?

I usually just lump everything into on shell script and run the shell
script from the oracle crontab

Example script would contain

#!/bin/ksh
export ORACLE_HOME=/home/oracle/product/9.2.0
export ORACLE_SID=myoraclesid
(other required environment vars here)

sqlplus user/pass @/home/oracle/place/where/my/sql/is/docoolstuff.sql

The output of that script could then be piped wherever you want it (|
mail [Email address protected] from your crontab entry.


--markr

Oracle LazyDBA home page