Hi,
This is my first thread.
Iam trying the following:
OS: Sun
Database: DB2, Informix, Oracle

* Get the status of the database (using database command line options)
* pipe to a text file
* send mail of the text file to receiptents.

TODO1:
First step i tried to send a test message.
sendmail myname@domain.com
This is test message (ctrl-d)

But when i check my mail box, i did not receive any message.
Where am i wrong? Any settings need to be done?

TODO2:
I have written a small shell script to get the status of the database (informix) and pipe it to a text file

something like:
onstat -d > track.txt

So the file "track.txt" will have the output of the database status.
I will be running this shell script using crontab say every 2 hours or so.

First i would like to add this file track.txt to the sendmail and send it to the receiptents.

Any leads how to add the file?

thanks

Instead of using 'sendmail', perhaps you want just 'mail'.

Try this and see how far it gets you:

# ls > ls.txt
# mail -s "ls output" youremail@yourhost < ls.txt

Then check your mail.

If you're sending to multiple recipients you may want to check to see if your mailer supports lists. Otherwise you'll have to write a script that opens up a file of recipients and loops over them:

onstat -d > onstat.txt
for r in `cat alertemails.txt`
do
mail -s "alert email" $r < onstat.txt
done

I think that will likely do what you want.

Good luck.

mailx is another option.

Thanks for your direction. I did check and the sendmail daemon was not running. The Systems dept guys had started the daemon and now iam able to send mail to single id.
Iam now looking at (as you specified) to sending mails to multiple recipitents.

1. If i understood right, i create a "alertemails.txt" which contains the list of emails and use this as per your script?
2. I put this in a script, execute with cron job and its done, right?

Also the cron daemon is not running and they (system guys) are looking at it. Once iam done, i shall update.