Solaris

crontab -l uoracle does not work.
do you mean crontabl -l oracle? if so, here is the output.

tama: /u01/app/oracle/jpark >crontab -l oracle
#30 10 * * * echo "testing cronjob" > /u01/app/oracle/crontest.txt
45 10 * * * /u01/app/oracle/jpark/sched_exp_mis.sh
tama: /u01/app/oracle/jpark >

Sorry, try

Code:

crontab -l oracle

It appears, so far, that your script calls another script or command that is not executable by user oracle.

Or the script attempts to write to the filesystem where the user oracle does not have write permissions.


Possible?

mrx1350,


If im correct your running the exp (export command of oracle). Maybe your ORACLE instance / Oracle PATH is not defined to that user , and that users doesnt have permission to run the exp command.

Thanks. Setting the path resolved this issue.

here's my 2 cents :

1) "exp" could be a typo (perhaps `expr' ?) ...

2) most probably , "exp" is an executable that is not being found due to PATH lookup failure ;

-- this second theory can be easily tested as follows :

a) try and run the script directly from the shell prompt (as if it was a `date' command) ;

-> if the same error occurs , then your script is messed up for good , and cron has nothing to do with it ;

-> if the error does NOT occur, then you need to adjust your PATH for cron jobs , because cron does NOT read your ".profile" ;

--> this can be done in many ways , but perhaps the simplest is by calling your special script from within an "envelope" shell script , that in turn prepares your PATH , see :

your cron line changes to :

10 10 * * * carrier.sh

the "carrier.sh" is :

PATH=/your/special/dir:$PATH
your_exp_mis.sh

( this is just for your to grasp the idea , ok )

now good luck , and success !

botao