Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: Help with executing parallel sessions for same shell script with different but fixed parameters
Top Forums Shell Programming and Scripting Help with executing parallel sessions for same shell script with different but fixed parameters Post 302481307 by R0H0N on Friday 17th of December 2010 06:40:33 AM
Old 12-17-2010
Code:
sys_date=`date '+%d_%m_%Y:%H:%M:%S'`
sysdate1=`date '+%d_%m_%Y`
sqlplus -s $ORA_CONN << EOF
SET SERVEROUTPUT ON
SET FEED OFF
spool org.txt
BEGIN
   FOR i IN (SELECT ID FROM table ID<>0)
   LOOP
      DBMS_OUTPUT.put_line ( i.ID);
   END LOOP;
END;
/
spool off
EOF
for i in `cat org.txt`
do
./subscript.ksh $i &
sleep 10
done
# Why do u need to fire a query in database to get records count??
org_cnt=`wc -l org.txt`
# Why 2 variables needed??
count=0
while [ ${count} == ${org_cnt} ]
do
    count=`grep 'Finished successfully' $LOG_FILE | wc -l`
    sleep 60
done

echo Report has been generated successfully ${report_name} with record count ${rec_cnt}

P.S. I have not added a code for appanding all completed process' individual log into common logfile. That u need to modify. Please revert if any doubt.
Last edited by R0H0N; 12-17-2010 at 07:46 AM..
This User Gave Thanks to For This Post:
Opamps123
R0H0N
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Problems executing SQL Plus sessions

If I execute this script: $ORACLE_HOME/bin/sqlplus -s <<EOF > oracle.log $DB_id/$DB_pswd@$DB_server start test.sql EOF the sql script executes with no errors. IF I execute the following script:... (12 Replies)
Discussion started by: mh53j_fe
12 Replies

2. Shell Programming and Scripting

Run a same script in parallel with diffs parameters

i have script say some_script.ksh that takes an argument I need to run some_script.ksh in background parallely at the sametime with different arguments. Once all the background jobs complete, i need to run this script again in parallel with another 5 set of arguments. Would really... (1 Reply)
Discussion started by: hyennah
1 Replies

3. Shell Programming and Scripting

Executing scripts in Parallel

Hi All, I have 3 shell scripts, Script1,Script2 and Script3. Now I want to run Script1 and Script2 in parallel and Script3 should depend on successful completion of both Script1 and Script2. Could you please suggest an approach of acheiving this... Thanks in advance (2 Replies)
Discussion started by: itsme_maverick
2 Replies

4. Shell Programming and Scripting

Optional Parameters/arguments while executing a script.

Hello, I have a shell script "Test.ksh" and I need to pass 8 parameters/arguments while executing the script ./Test.ksh 1 2 3 4 5 6 7 8 Out of these I want first 3 to be compulsory and rest 5 to be optional. Can you suggest the way to do this like and also how to pass these optional... (3 Replies)
Discussion started by: indrajit_u
3 Replies

5. Shell Programming and Scripting

Executing two commands in parallel

Hi, I am stuck into a situation where i want to execute a command in my shell script well along with a previous command in order to achieve something but i am not figuring out a way. here is a snippet: service management restart rm -rf lock.file in the above, if you see, i am trying to... (5 Replies)
Discussion started by: sunrexstar
5 Replies

6. Shell Programming and Scripting

Parallel SQL sessions in shell script

i have 3 sqls , sql 1 and sql 2 shuld run in parallel , but sql 3 should run after completion f sql1 nd sql2, my code is as below, please suggest the changes sqlplus username1/password1@DB1 @sql >> log1 & sqlplus username2/password2@DB2 @sql2 >> log1 & how can i execute the... (7 Replies)
Discussion started by: only4satish
7 Replies

7. Shell Programming and Scripting

Executing Multiple Queries in parallel in Shell

I have n number of SQL queries needs to executed in Shell. Result of this query need to assign in a variable. Once all the queries are executed script needs to exit. Sample Query: SQL 1: Select Count(*) from TABLE GROUP BY COL1,COL2 SQL 2: Select Count(*) from TABLE GROUP BY COL1,COL2 ... (2 Replies)
Discussion started by: Niranjancse
2 Replies

8. Shell Programming and Scripting

Pass parameters to a function and running functions in parallel

Hi , I have a script which is using a text file as I/P. I want a code where it reads n lines from this file and pass the parameters to a function and now this script should run in such a way where a function can be called in parallel with different parameters. Please find below my script, it... (1 Reply)
Discussion started by: Ravindra Swan
1 Replies

9. Shell Programming and Scripting

Parallel for in a Script Shell

Hello, This is my Script which configure a list of nodes. ( 40 nodes, and the configuration 10 minutes) #! /bin/sh if then echo "USE: ./start.sh nodes else nb_lignes=`wc -l $1 | cut -d " " -f1` echo "$nb_lignes machines" for i in $(seq $nb_lignes) //instructions done fi My... (2 Replies)
Discussion started by: chercheur111
2 Replies

10. UNIX for Beginners Questions & Answers

Executing SQL's in parallel

Hi Folks, I have requirement to pull a bunch of SQL's from a table in DB and execute them in parallel and update the status of each query as and when they complete. Can you please help me with ideas on how this can be achieved? create table list_of_sql ( id number, full_sql... (3 Replies)
Discussion started by: member2014
3 Replies

LEARN ABOUT REDHAT

nwfstime

NWFSTIME(1)							     nwfstime							       NWFSTIME(1)

NAME

       nwfstime - Display / Set a NetWare server's date and time

SYNOPSIS

       nwfstime [ -h ] [ -S server ] [ -U user name ] [ -P password | -n ] [ -C ] [ -s ]

DESCRIPTION

       nwfstime displays a NetWare server's date and time. You can also set a NetWare server's date and time from the local time.

OPTIONS

       -h
	  With -h nwfstime prints a little help text.

       -S server
	  is the name of the server you want to use.

       -U user
	  user is the user name to use for login. To set the server's time, you need supervisor privileges.

       -P password
	  password  is	the password to use for login. If neither -n nor -P are given, and the user has no open connection to the server, nwfstime
	  prompts for a password.

       -n
	  -n should be given if no password is required for the login. As you need supervisor privileges for  setting  the  date  and  time,  this
	  option is probably not used very often.

       -C
	  By default, passwords are converted to uppercase before they are sent to the server, because most servers require this. You can turn off
	  this conversion by -C.

       -s
	  With -s, nwfstime sets the file server's date and time according to the local date and time.

nwfstime							    12/10/1996							       NWFSTIME(1)
All times are GMT -4. The time now is 06:59 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy