Hi all,
I hope someone can help me. I have a scirpt that does not seem to be running via cron. It's basically something written by one of our developers to export some Oracle databases every night. It runs fine from the command line but does not work via cron.

The script:
[root@localhost script]# ls -al secfin
-rwxr-xr-x 1 oracle oracle 259 Dec 5 17:48 secfin


#!/bin/sh
logfile="secfin`date +%a%b%d`.log"
dmp="secfin`date +%a%b%d`.dmp"
path=/home/oracle/backup/secfin/

echo $path
echo $dmp
echo $path

exp system/manager@secfin FULL=Y file=/home/oracle/backup/secfin/"$dmp" log=/home/oracle/backup/secfin/"$logfile"


The crontab:
[root@localhost ~]# crontab -u oracle -l
30 0 * * 1-5 /home/oracle/backup/script/secfin


So if I su to oracle and cd to /home/oracle/backup/script followed by ./secfin it works fine but via cron no joy.

The cron log shows:

Dec 28 00:30:01 localhost crond[19465]: (oracle) CMD (/home/oracle/backup/script/secfin)

I'm a bit stuck at this point If there is any one out there that can help I'd be eternally grateful. If there is any more info needed please let me know.

Many thanks

Jon