10-28-2009
counter
Hi,
I need some help.
Shell script counter. i need to add condition to check if counter is more than 10 and longer than 3 hours? it runs every 5 mins. it only check count and send email right now.
it runs in cron as below
gregcount.ksh gregdb 10 > /tmp/gregcount.out 2> /tmp/gregcount.err
if [ $# -ne 2 ]
then echo "Usage: $0 DB MAX_ALLOWED "
exit
fi
DB=$1
MAX_ALLOWED=$2
MAIL_LIST=bob
CNT=`${ORACLE_HOME}/bin/sqlplus -s \/nolog << EOF | tail +1 2>/dev/null
set pages 0
set head off
set feedback off
set termout off
set verify off
set echo off
connect system/${SYS_PWD}@${DB}
select count(*) from greg.counter;
EOF`
# echo $CNT
if [ $CNT -gt $MAX_ALLOWED ]
then mailx -s "too many ( ${CNT} ) in $1 !! " $MAIL_LIST < /dev/null
else
echo "All is well !! "
fi
Last edited by pega; 10-28-2009 at 11:03 PM..
9 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi,
I have such an example(ksh):
name1=Example
directory=/directory1/Example/directory2
match=$(grep -s '$name1' $directory | wc -l)
echo $match
But it replies to me:
0
What I expect from it, is to find $name1 in $directory and produce 1 for me as true, not false. (3 Replies)
Discussion started by: chish
3 Replies
2. UNIX for Dummies Questions & Answers
Dear all,
I have numerous dat files (a.dat, b.dat...) containing 500 numeric values each. I would like to count them, based on their range and obtain a histogram or a counter.
INPUT:
a.dat
1.3
2.16
0.34
......
b.dat
1.54
0.94
3.13
.....
... (2 Replies)
Discussion started by: chen.xiao.po
2 Replies
3. Shell Programming and Scripting
cat sport_by_month
Month : Jan
sport :Football
sport :Volleyball
Month: Feb
sport :BasketBall
sport: Cricket
sport: Fotball
Month: Mar
Month: APR
sport : Bowling
sport : Climbing
I need your help to have a script that count the number of sports per month and sorted by mont with... (7 Replies)
Discussion started by: Sara_84
7 Replies
4. Shell Programming and Scripting
i having a file
xxxxxxxxxxxxxxx1234 ...........value can be change
xxxxxxxxxxxxxxx1235
xxxxxxxxxxxxxxxx1236
.
.
.
.
xxxxxxxxxxxxxxxxx1300 ...........value can be change
i want to cut last four characters of first line and last line and find the missing pattern.
output should... (4 Replies)
Discussion started by: sagar_1986
4 Replies
5. Shell Programming and Scripting
if ;then
echo "mrnet greater 5000"
gzip /var/log/mrnet.log
mv /var/log/mrnet.log.gz /var/log/mrnet.log.1.gz
if ];then
i=1
let i++
mv /var/log/mrnet.log.1.gz /var/log/vieux-logs/mrnet.log.$i.gz
else
echo "theres no... (1 Reply)
Discussion started by: Froob
1 Replies
6. Shell Programming and Scripting
I have this file
1801,A1,2012-12-16 15:59:59.995,id2_3,ab,phoneC2-00,VOE,,,,,,,,,,,,,,,
1802,A1,2012-12-16 15:59:59.995,id2_3,ab=,phoneX1-01,BL,,,,,,,,,,,,,,,
1803,A1,2012-12-16 15:59:59.995,id2_3,ab,phone300,BL,,,,,,,,,,,,,,,
1804,A1,2012-12-16... (4 Replies)
Discussion started by: nikhil jain
4 Replies
7. Shell Programming and Scripting
For the following code
SEQ=200
awk -v S="$SEQ" '
$0 ~ S {
N++
print N
}
' "$1"ascii >"$1"search
N is printed 8002 times as it occurred 8002 times in file
how I could print the counter one time only (20 Replies)
Discussion started by: khaled79
20 Replies
8. UNIX for Dummies Questions & Answers
Hi Experts,
I am in need for some help. My competence level on unix is not at all helping me to resolve this. Please help.
My Input for a system command is as under:
Counters are getting pegged each hour. I need to have a difference printed rather than pegged counter values.
Counter... (2 Replies)
Discussion started by: vanand420
2 Replies
9. Shell Programming and Scripting
hello
this script should show all users and space they used without problem :
ls /home >> /root/users.txt
cat /root/users.txt | while read line; do
space=`du -s /home/$line`
echo "$line space is $space"
shift
done
but when i remove pipe ,script run without any output:
ls /home... (4 Replies)
Discussion started by: nimafire
4 Replies
escape(1) Mail Avenger 0.8.3 escape(1)
NAME
escape - escape shell special characters in a string
SYNOPSIS
escape string
DESCRIPTION
escape prepends a "" character to all shell special characters in string, making it safe to compose a shell command with the result.
EXAMPLES
The following is a contrived example showing how one can unintentionally end up executing the contents of a string:
$ var='; echo gotcha!'
$ eval echo hi $var
hi
gotcha!
$
Using escape, one can avoid executing the contents of $var:
$ eval echo hi `escape "$var"`
hi ; echo gotcha!
$
A less contrived example is passing arguments to Mail Avenger bodytest commands containing possibly unsafe environment variables. For
example, you might write a hypothetical reject_bcc script to reject mail not explicitly addressed to the recipient:
#!/bin/sh
formail -x to -x cc -x resent-to -x resent-cc
| fgrep "$1" > /dev/null
&& exit 0
echo "<$1>.. address does not accept blind carbon copies"
exit 100
To invoke this script, passing it the recipient address as an argument, you would need to put the following in your Mail Avenger rcpt
script:
bodytest reject_bcc `escape "$RECIPIENT"`
SEE ALSO
avenger(1),
The Mail Avenger home page: <http://www.mailavenger.org/>.
BUGS
escape is designed for the Bourne shell, which is what Mail Avenger scripts use. escape might or might not work with other shells.
AUTHOR
David Mazieres
Mail Avenger 0.8.3 2012-04-05 escape(1)