Hi All
I have this sql script lets say abc.sql
How to run this script with this following conditions :
1 - The script will run everyday and mailx to me by using crontab
2 - The output of this script will be saved to someplace and attach with mailx OR can be display as email text and then send to me

Point 1:
You have to edit the crotab using crontab -e to add the entry like:
00 02 * * * sh /tmp/your_script.sh | /usr/bin/mailx "user@domain.com" -s "Subject here"
Point 2:
You can do like:
00 02 * * * sh /tmp/your_script.sh >out_log && uuencode out_log | /usr/bin/mailx "user@domain.com" -s "Subject here"

Mail can be sent to ur mailbox by using .

/usr/bin/mailx -s " subject whatever" usermail id

check it out

Hi
i managed to attached the file using this command :
uuencode /ek_bkup/alert/tbspace_datafile.log tbspace_datafile.log | mailx -r oraadm@juwpkl.gov.my -s\
"Oracle Tspace and Datafile Update" adzuan@nc.com.my

BUT after i download the file attached to my email, the tbspace_datafile.log is not being recognize. The file cant be read although i'm using context, wordpad or notepad...

Anybody can update this??