RE: shell scripting help

From: Allen, Brandon <Brandon.Allen_at_OneNeck.com>
Date: Wed, 3 Aug 2005 14:54:33 -0700
Message-ID: <04DDF147ED3A0D42B48A48A18D574C45023613C9@NT15.oneneck.corp>

David,

I believe if you just put a 'wait' command after your first 3 sqlplus commands, the script will stop at that point until the first 3 complete, e.g.

sqlplus . . . &
sqlplus . . . &
sqlplus . . . &

wait

sqlplus . . .

Regards,
Brandon Allen

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of d cheng Sent: Wednesday, August 03, 2005 2:49 PM To: Oracle-L_at_freelists.org
Subject: shell scripting help

Hi Listers,

I have a korn shell script which needs to run 3 sqlplus scripts in parallel then run the final sqlplus script. Is there a way to ensure that sqlplus scripts 1 thru 3 completes before running the final sqlplus script? I am a newbie in shell scripting.

<< shell script snippet >>
...

sqlplus un/pw @script1.sql &
sqlplus un/pw @script2.sql &
sqlplus un/pw @script3.sql &

...

sqlplus un/pw @final.sql
...

exit

Thank you in advance for your help!

David

Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com

Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Aug 03 2005 - 16:55:14 CDT