hi everyone
i'm having a problem executing a sheduled job from crontab
i'm trying to start a backup script for my oracle database from crontab .
the command line in the crontab is :
12 12 * * * /home/oracle/backup.sh
backup.sh is as folows:
exp useid=..... file=...... log =...
as you can see , the command to be executed is "exp" and this command cannot be executed as user root but only as user oracle
i've tried editing the crontab file for the user oracle :
crontab -u oracle -e
but i still get the same error :
exp : command not found
when i start the script manualy , everuthing works just fine
i'm assuming the reason is that crontab is trying to execute the script as root and it cannot recognize the command.
how can i edit the crontab file so that it starts the script as user oracle?????
i've tried to set the crontab like this:
12 12 * * * oracle /home/oracle/backup.sh
but then i get the error :
oracle:command not found
please help , i've tried everything