Hi Folks,

I have created a number of unix scripts that i can run from the scheduler on a server-side application that we use (Chordiant Marketing Director). All scripts are working except one. This last script is a user load script which first truncates a table and then loads it using a flat file. The script comprises of a ctl file, a sql file (for truncating), a data file, a generic load script and an oracleset.ini file. When I run it directly from a unix session (Telnet) everything works, but when I try to run it from the application it gives me a status of completed but doesn't actually do anything. I have set permissions on all files and directories to rwxrwxrwx but still no success. I have tried several different unix accounts but none of them work (including the master user that owns all of the scripts and files). Is there anything obvious that I could be missing here?

Any help much appreciated.

Cheers,

James

The first thing to check is the environment variables in the scheduled script.
Next make sure the script redirects stderr and stdout to the same log file.

cron jobs run with a different environment - eg. $ORACLE_HOME probably is not defined.

When running such a script it is most of the times the best way to set (reset) all the system parameters needed so you are sure that they are there and that the values are correct.



Regards,
Johan Louwers. http://www.terminalcult.org