Shell Programming and Scripting

I have the following ksh script:

Code:

sqlplus usr1/pw1@DB1 @$DIR/a.sql $1 &
sqlplus usr2/pw2@DB2 @$DIR/b.sql $1 &
wait
echo "Done!"

Where $DIR is a variable with the absolute path where a.sql and b.sql are.

For some time, I've been running this script daily and it works fine. The intentions is that both SQL*Plus sessions go to the background and execute in parallel, and when they finish I can continue with the following steps of the application.

Since it's not a test version anymore, I scheduled it on the crontab to execute daily. The problem I have now is that it wont pause on "wait" and let the sqlplus sessions finish, but it directly outputs "Done!". In the real app, that "echo Done!" is actually a call to another program to do some processing on a.sql's and b.sql's output. But since it's not waiting for both sql scripts to actually finish, the processing cannot be done.

It works absolutely perfect when I run it myself, wether I do it from the local directory or from the root (as crontab would do it). But when it is executed automatically by the crontab, I't doesn't stop at wait and screws the whole thing up.

Any ideas on what might be happening? Thanks!

Does your script start with #!/bin/ksh in the first line? If not, insert it and see, if it makes any difference.

It does...

Please post what Operating System and version you are running:

Code:

uname -a # Blotting anything confidential with Xs

And what version of Oracle you have.

The Korn Shell script as posted should work if it is invoked directly with full path as an executable script.
Please post the relevant line from crontab and a full directory listing of the script.

The "wait" not work if the "sqlplus" lines are actually other scripts which start a new Shell.

I finally solved it. The problem was not thw "wait".

The sqlplus sessions weren't executing and there was nothing to wait for. I added the oracle path to the sqlplus calls, but still didnt work.

I had to do this at the begining of the file:

Code:

. /ora01/DWHR/files/relacional/.profile

Thanks for your help

Thank you for letting us know.

. /ora01/DWHR/files/relacional/.profile

Actually I can't imagine how this works unlesss it is preceded by a cd command or the environment script is in the home directory of the owner of the crontab.
Wherever possible use absolute path names in scripts run from cron.