in reply to Re: Need Help regarding perl script in unix cronjob...
in thread Need Help regarding perl script in unix cronjob...

I agree with [id://Joost]. More than likely, ORACLE_HOME is set for your user environment but not for your cron. We have a standardized wrapper for cron jobs:

#!/bin/sh # # Generic cron job wrapper # # Modify recipient list as needed. RECIPIENTS="root@foo.com" CRON_OUTPUT=/tmp/cron.output.$$ ( ########################################################### # Insert cron job statements here # PREFIX=/path/to/job # ENV_VAR=what_you_need # export ENV_VAR # cd $PREFIX # ./job ########################################################### ) > $CRON_OUTPUT 2>&1 if [ -s $CRON_OUTPUT ] then ( echo 'Your "cron" job on '`hostname` echo "" echo "$0" echo "" echo "produced the following output:" echo "" cat $CRON_OUTPUT ) | mail -s 'Output from "cron" command' $RECIPIENTS fi /bin/rm $CRON_OUTPUT
Maybe a bit overkill but by always using a wrapper, I never forget (well almost never) to set need env vars.

-derby