RE: shell scripting help

From: Reidy, Ron <Ron.Reidy_at_arraybiopharma.com>
Date: Wed, 3 Aug 2005 15:55:31 -0600
Message-ID: <17CAB0BF27BCFC47B0E4554A0E2F962B873232@fiji.arraybp.com>

Try wait(1).

Ron Reidy
Lead DBA
Array BioPharma, Inc.

-----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 3: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

This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. Please notify the sender of the delivery error by replying to this message, or notify us by telephone (877-633-2436, ext. 0), and then delete it from your system.

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

Received on Wed Aug 03 2005 - 16:58:27 CDT