Kalyan

• Oct 18th, 2005

 

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

Kwisatz_Haderach

 Profile Answers by Kwisatz_Haderach 

• Feb 1st, 2011

 

Create sql file name_of_file.sql

In name_of_file.sql file

output to pipe 'mailx -s "SUBJECT"  mail_recepient' select * from table;


Create a unix script name  "whatever"

#!/bin/bash
#  whatever
#  source in Informix environment

. /opt/informix/informix.rc

# cd to location of name_of_sql.sql

cd /home/informix/sql

$INFORMIXDIR/bin/isql -qcr dbname@$INFORMIXSERVER  ./$1


crontab entry

0 5 * * * . ~/.cron_profile;$HOME/scripts/whatever  name_of_file 1>/dev/null 2>&1