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
Received on Tue May 25 2004 - 21:32:04 CDT
