Login or Register to Ask a Question and Join Our Community


Shell Programming and Scripting

Crontab query !!

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Crontab query !!
# 8  
Old 04-05-2013
/home/ramesh/bin/connectdb1.sh takes 15 mins to complete execution as it fires a PLSQL query to the database.

Will your example wait for 15 mins for each script to complete before setting the value for rc1 ?

I was looking for executing all the three connectdb scripts to run parellely.

Also, please tell me what does -a and -o stand for in your example?
Last edited by mohtashims; 04-05-2013 at 09:01 AM..
# 9  
Old 04-05-2013
Quote:
Originally Posted by mohtashims
Will your example wait for 15 mins for each script to complete before setting the value for rc1 ?
I was looking for executing all the three connectdb scripts to run parellely.
Yes, It does wait till ur connected1.sh gets complete. Sorry, I didn't notice the time lag. Smilie

Quote:
Originally Posted by mohtashims
Also, please tell me what does -a and -o stand for in your example?
-a => Logical AND
-o => Logical OR

You could use -a in both the cases. Sorry I added both.

What you can actually do is, you could export a variable from each of your scripts. say
Code:
export SCRIPT1="SUCCESS" #in case of successful execution

You can do the same to the other two as well. So the script can be modified as

Code:
#! /bin/sh

echo "Starting up 1st script"
/home/ramesh/bin/connectdb1.sh &
echo "Starting up 2nd script"
/home/ramesh/bin/connectdb2.sh &
echo "Starting up 3rd script"
/home/ramesh/bin/connectdb3.sh &

#Wait till all the scripts completes
while [ $(ps -ef | grep -c "connectdb") -ne 0 ]; then
do
       if [ "$SCRIPT1" = "SUCCESS" -a "$SCRIPT2" = "SUCCESS" -a "$SCRIPT3" = "SUCCESS" ]; then
             echo "Starting up 4th script"
             /home/ramesh/bin/calculate.sh
       else
             #mail logic here
             exit
       fi
done
echo "All scripts completed successfully"
exit

This User Gave Thanks to PikK45 For This Post:
mohtashims
# 10  
Old 04-08-2013
I will update you with my finding and queries if any in 30 days time. Hope that does not make this thread stale.
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Shell Script to execute Oracle query taking input from a file to form query

Hi, I need to query Oracle database for 100 users. I have these 100 users in a file. I need a shell script which would read this User file (one user at a time) & query database. For instance: USER CITY --------- ---------- A CITY_A B CITY_B C ... (2 Replies)
Discussion started by: DevendraG
2 Replies

2. UNIX for Dummies Questions & Answers

Query

Hi, I have a script to remove null values from a file. Could any one explain how this is working? :confused: while read f do echo process $f gawk... (0 Replies)
Discussion started by: abhi_n123
0 Replies

3. Shell Programming and Scripting

want to query : YES or NO

hi i want to make script. where i want to query from the user yes or no exp: do you want to proceed : y for yes n for NO. how this is possible in unix (3 Replies)
Discussion started by: dodasajan
3 Replies

4. Shell Programming and Scripting

Query Oracle tables and return values to shell script that calls the query

Hi, I have a requirement as below which needs to be done viz UNIX shell script (1) I have to connect to an Oracle database (2) Exexute "SELECT field_status from table 1" query on one of the tables. (3) Based on the result that I get from point (2), I have to update another table in the... (6 Replies)
Discussion started by: balaeswari
6 Replies

5. Shell Programming and Scripting

Query

hi i am producing txt outputs of archives created by our tsm software. problem is some of these files are too large to open in excel so i can despatch. here is a example of the output TAG_460 /prod_bak 7 FILE /ARCHIVE/Whistles- ... (4 Replies)
Discussion started by: treds
4 Replies

6. Shell Programming and Scripting

add the output of a query to a variable to be used in another query

I would like to use the result of a query in another query. How do I redirect/add the output to another variable? $result = odbc_exec($connect, $query); while ($row = odbc_fetch_array($result)) { echo $row,"\n"; } odbc_close($connect); ?> This will output hostnames: host1... (0 Replies)
Discussion started by: hazno
0 Replies

7. UNIX for Dummies Questions & Answers

Need Help on query

I just started to learn unix - need help to write a script to query a logfile and produce the results that contains a specific word "alarm" for a period from X day to Y day. I really have no idea how to begin - :( please help... ____________________________________________________ #... (1 Reply)
Discussion started by: snipfer
1 Replies

8. Shell Programming and Scripting

query.....

hi friends i want to know details of `exec` exact use of this command ..... actually i went through the man page but i didn`t get the satisfactory ...conclusion.... thaks in advance.... (1 Reply)
Discussion started by: newson
1 Replies

9. Shell Programming and Scripting

query

I have converted data written on excel sheet in unix through shell & perl prg now the problem is I want that if starting columns of the xls sheet is Blank than when data is converted into unix then it should appear with this '|' sign. but it appearing like this: hfgg|tytt| but I want like... (2 Replies)
Discussion started by: akash
2 Replies

10. UNIX for Advanced & Expert Users

query

hello, i am working as aix system administrator, what is the major difference between aix and sun solaris ..os. what r the area difficult in solaris for aix administrator .............................. (1 Reply)
Discussion started by: varadakumar
1 Replies
Login or Register to Ask a Question