Shell Script Error


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting Shell Script Error
# 1  
Old 03-17-2009
MySQL Shell Script Error

Hi Friend,

I wrote below script to run every saturday and suny with intervel of 4hrs, but it's not running in both days.
Kindly help on this....

#!/bin/ksh
INTERVAL=3600
INTERVAL1=14400
export INTERVAL
DAY=`date|cut -f1 -d ' '`
export DAY
COUNT=500
export COUNT

export CTR=0
while [ true ]
do
if [ ${CTR} -ge ${COUNT} ]
then
exit
fi
for DAY in Sat Sun
do
INTERVAL=$INTERVAL1
done
/home/mg01800/scripts/send_output.sh
CTR=$(expr ${CTR} + 1)
sleep ${INTERVAL}
done
# 2  
Old 03-17-2009
Quote:
Originally Posted by tsreddy
Hi Friend,

I wrote below script to run every saturday and suny with intervel of 4hrs, but it's not running in both days.
Kindly help on this....

#!/bin/ksh
INTERVAL=3600
INTERVAL1=14400
export INTERVAL
DAY=`date|cut -f1 -d ' '`
export DAY
COUNT=500
export COUNT

export CTR=0
while [ true ]
do
if [ ${CTR} -ge ${COUNT} ]
then
exit
fi
for DAY in Sat Sun
do
INTERVAL=$INTERVAL1
done
/home/mg01800/scripts/send_output.sh
CTR=$(expr ${CTR} + 1)
sleep ${INTERVAL}
done
you better cron those jobs on sat and sun like below
Code:
00 0,4,8,12,16,20 * * 6,7 /home/mg01800/scripts/send_output.sh

# 3  
Old 03-17-2009
Thankyou...

I don't have permission to update crontab....
# 4  
Old 03-17-2009
Quote:
Originally Posted by tsreddy
Hi Friend,

I wrote below script to run every saturday and suny with intervel of 4hrs, but it's not running in both days.
Kindly help on this....

#!/bin/ksh
INTERVAL=3600
INTERVAL1=14400
export INTERVAL
DAY=`date|cut -f1 -d ' '`
export DAY
COUNT=500
export COUNT

export CTR=0
while [ true ]
do
if [ ${CTR} -ge ${COUNT} ]
then
exit
fi
for DAY in Sat Sun
do
INTERVAL=$INTERVAL1
done
/home/mg01800/scripts/send_output.sh
CTR=$(expr ${CTR} + 1)
sleep ${INTERVAL}
done
I agree it should be set as a cron job.

But I think the problem with your script is having "done" in the wrong place.

Code:
export CTR=0

while [ true ]
  do

    if [ ${CTR} -ge ${COUNT} ]
    then
      exit
    fi

    for DAY in Sat Sun
    do
      INTERVAL=$INTERVAL1
      /home/mg01800/scripts/send_output.sh
    done

    CTR=$(expr ${CTR} + 1)
    sleep ${INTERVAL}
              
 done

But I can't figure out why you set interval to 3600 at the beginning, and then overwrite it later on before you do anything with it.
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Shell script with sql script error

Hi All when I execute from psql prompt, I get the result, when I try to automate using a shell script, the query is not working # `/usr/bin/psql -U postgres -d coba1 -c "select name from users where "Date" > current_date - 30;"` ERROR: column "Date" does not exist LINE 1: select... (2 Replies)
Discussion started by: srilinux09
2 Replies

2. Shell Programming and Scripting

Calling shell script within awk script throws error

I am getting the following error while passing parameter to a shell script called within awk script. Any idea what's causing this issue and how to ix it ? Thanks sh: -c: line 0: syntax error near unexpected token `newline' sh: -c: line 0: `./billdatecalc.sh ... (10 Replies)
Discussion started by: Sudhakar333
10 Replies

3. Shell Programming and Scripting

Error in calling a shell script from another script

HI, We are using two shell scripts, script.sh,env.sh, where env.sh will be called inside script.sh. The variable inside env.sh is used as $var in script.sh.But while running the script its not identifying that variable. Is there any permission needed to call a script inside another script. ... (3 Replies)
Discussion started by: banupriyat
3 Replies

4. Shell Programming and Scripting

Syntax error calling TCL script from shell script

hello everyone i am beginner on shell scripting .and i am working on my project work on ad hoc network i wrote a batch (.sh) to do a looping and execute a tcl script i wrote before in each iteration ..but i got this problem " syntax error near unexpected token `('... (1 Reply)
Discussion started by: marcoss90
1 Replies

5. Shell Programming and Scripting

Error in Shell script

Hello All, I am newbe to scripting and have just taken over following script from previous developer. I am getting following error when running the script. line 70: syntax error near unexpected token `do Could some help me to rectify the error please. Thanks in advance for your... (9 Replies)
Discussion started by: Pahadia
9 Replies

6. Shell Programming and Scripting

How to grep sql error in shell script and exit the script?

I need help in the following script. I want to grep the sql errors insert into the error table and exit the shell script if there is any error, otherwise keep running the scripts. Here is my script #!/bin/csh -f source .orapass set user = $USER set pass = $PASS cd /opt/data/scripts echo... (2 Replies)
Discussion started by: allinshell99
2 Replies

7. Shell Programming and Scripting

Shell script error

Hi, I have the following table in MYSQL: (the structure looks broken in this forum but if you copy/paste it into notepad, it'll look right): +----------------------------+-----------------------+------+-----+---------+----------------+ | Field | Type |... (0 Replies)
Discussion started by: tezarin
0 Replies

8. UNIX for Dummies Questions & Answers

awk Shell Script error : "Syntax Error : `Split' unexpected

hi there i write one awk script file in shell programing the code is related to dd/mm/yy to month, day year format but i get an error please can anybody help me out in this problem ?????? i give my code here including error awk ` # date-month -- convert mm/dd/yy to month day,... (2 Replies)
Discussion started by: Herry
2 Replies

9. UNIX for Dummies Questions & Answers

error in shell script

Hi, I have written a small shell script which logs into each oracle database on the server and displays whether it is in archivelog mode or not.. The script is as under: #!/bin/bash dblist=`ps -ef | grep smon | grep -v grep |cut -d'_' -f3` for ohome in $dblist; do sqlplus -s /nolog <<... (2 Replies)
Discussion started by: jalpan.pota
2 Replies
Login or Register to Ask a Question