How do I write a cron which will run a SQL query and mail the results to a group?

Kwisatz_Haderach

 Profile Answers by Kwisatz_Haderach Questions by Kwisatz_Haderach

• Feb 1st, 2011

Create sql file name_of_file.sqlIn name_of_file.sql file output to pipe 'mailx -s "SUBJECT"  mail_recepient' select * from table;Create a unix script name  "whatever&q...

Kalyan

• Oct 18th, 2005

Use DBMS_JOB for scheduling a cron job and DBMS_MAIL to send the results throught email.

Answer Question  Select Best Answer