Re: OT: Unix Question

From: Jared Still <jkstill_at_cybcon.com>
Date: Wed, 26 May 2004 07:35:35 -0700
Message-Id: <1085582114.13680.0.camel@poirot>

*nix lives by files. it eats and breathes files. *everything* is a file.

use a file.

Jared

On Tue, 2004-05-25 at 19:34, Ryan wrote:
> Its related to Oracle. I need to parallelize some SQL. I need to use korn shell to do it. My problem, is how do I run multiple processes in the background and return the exit status from each one? So I can know when to check for errors.
> One way is to write the exit statuses to a file. I would prefer not to do that. This is what I have right here.
>
> nohup run_sql $ERROR_MSG_OPTION -u $LOGIN_FILE_NAME $SQL_SCRIPT1 2>&1 > sql_script1.log; message "$? $SQL_SCRIPT1" $STATUS_FILE &
> nohup run_sql $ERROR_MSG_OPTION -u $LOGIN_FILE_NAME $SQL_SCRIPT2 2>&1 > sql_script1.log;
> message "$? SQL_SCRIPT2" $STATUS_FILE &
> wait
>
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Wed May 26 2004 - 09:25:03 CDT