In my script, I have log files but I cannot see it. I guess the job fails directly withoutYes that is what I mean to have redirection in your script itself. Perhaps have a simple
hitting the redirection line in the script.
But OS user and database user are two different accounts at different level.Right and external jobs need to run as some OS user. On 10.2.0.2 regular user external jobs run an the OS user that owns the $ORACLE_HOME/bin/extjob executable which is nobody by default (and typically nobody can't do a lot).
I am using 10.2.0.2 RAC. The Unix script runs successfully every night.