UNIX for Dummies Questions & Answers

Hi,

I want to run the below 3 sql files parallely..I know adding a "&" at the end

of the command will make it run in background.But each sql file will take

a considerable time to execute so i want to apply "nohup" to this execution.

Help me how to use " nohup " to these...

echo $PASSWD | $ORACLE_HOME/bin/sqlplus -s dls_rep@$2 @$DM_DIR/$2/$1/JOB/dimA.sql &

echo $PASSWD | $ORACLE_HOME/bin/sqlplus -s dls_rep@$2 @$DM_DIR/$2/$1/JOB/dimB.sql &

echo $PASSWD | $ORACLE_HOME/bin/sqlplus -s dls_rep@$2 @$DM_DIR/$2/$1/JOB/dimC.sql &

Thanks.

Try something like this

Code:

nohup echo $PASSWD | $ORACLE_HOME/bin/sqlplus -s dls_rep@$2 @$DM_DIR/$2/$1/JOB/dimA.sql > log1 &
...
wait   # now you don't have to worry about disconnecting

Othwerwise all of the output from those three will be sprinkled into ./nohup.out

Thanks!!

I have already directed the output to Logs folder like

LOGS=/ora05/fnfis/LOAD_logs; export LOGS

then i execute the 3 sql's and direct to > LOGS

You mean now if i dont redirect to log1 as you specified then

will it be redirected to nohup.out ??