automatic mail generation when cron job executes???

[21sam]

can you guys give some guidence to setup the automatic mail generation to dba groups whenever the cron job runs. this LPAR is AIX 5.2ML07 and Oracle database is running...

advance thanks for your valuable reply

thanks
samy

 

[columb]

Can you give a more detailed description of your problem. In simple terms if the cron job is

00 23 * * * /home/oracle/myscript.ksh

Then /home/oracle/myscript.ksh could be

/home/oracle/do_the_real_work.ksh
echo "do_the_real_work completed with exit status $?" | mail -s "Do the real work" dbauser@dbahost

But you can add far more bells and whistles if you want.

Columb Healy

 

[21sam]

thank you so much!

with your input i will try to read further to fix the problem.

thanks