I'm relatively new to Oracle (just now taking my Oracle DBA certification
classes for 9i), so please be gentle.

I have an Oracle 9i database on a Linux box and I want to e-mail the output
of a simple SQL script on a daily basis.

SQL script example:

SELECT COUNT(*)
FROM table;

I can e-mail other Linux command line tasks by adding '| mail -s "subject"
[Email address protected] after the command.

For example, my CRON table on a different Linux box has the entry:

0 0 * * * su - cyrus -c quota | mail -s "Account Quotas (mail.domain.com)"
[Email address protected]

Which mails the e-mail account quotas to me on a nightly basis.

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

Thank you.

Josh Graves
http://www.thegeeksite.com
http://www.geneamap.com


Oracle LazyDBA home page