Ah ok, so you want to remember which last status it had. Yep you could just create a lock file, that keeps the latest status in it which will be tested against the actual status. Also I would set a lock to avoid running the script more than 1 times. If you stop it with a kill, you will have to manually remove the .lck file - maybe can put a trap in there for this.
I might write it for example like this:
Code:
#!/bin/bash
#
# Skript to check DB status and send an email as warning
#
# Error codes:
# 0 ok
# 1 already running or lock file left over
#
# v1.0, 27.07.11
###################################################################
#set -x
DATE=`date +%Y-%m-%d", "%H:%M:%S`
SNAME=`echo $0| sed 's/^.\///'`
BASE=/home/d3xt3r
LOCKDIR=${BASE}/var/.lock
LOCKFILE=${LOCKDIR}/${SNAME}.lck
STATFILE=${BASE}/var/DB_STAT
MAILTO=d3xt3r@bla.org
INTERVAL=10
if [[ -e $LOCKFILE ]]; then
echo "Sorry, $SNAME seems to run already; lockfile $LOCKFILE already exists."
exit 1
else
touch $LOCKFILE
fi
mailit()
{
echo "$DATE - $1"
echo "$DATE - $1"| mail -s "Database status inside..." $MAILTO
}
writestat()
{
echo $1 > $2
}
getstat()
{
#DB_STAT=`ps -ef| grep -v grep| grep ${ORACLE_SID}|grep -c pmon`
DB_STAT=`ps -ef| grep -v grep| grep -c cron`
}
## Write initial status to file
getstat
case $DB_STAT in
"0") writestat DOWN $STATFILE;;
"1") writestat UP $STATFILE;;
esac
while :; do
getstat
if [[ $DB_STAT > 0 ]]; then
STAT=UP
if [[ `cat $STATFILE` == "DOWN" ]]; then
writestat $STAT $STATFILE
MSG="Database is $STAT again."
mailit "$MSG"
else
echo "$DATE - Database is $STAT."
fi
sleep $INTERVAL
continue
else
STAT=DOWN
if [[ `cat $STATFILE` == "DOWN" ]]; then
echo "$DATE - Database is still $STAT."
else
writestat $STAT $STATFILE
MSG="Database is $STAT."
mailit "$MSG"
fi
sleep $INTERVAL
continue
fi
done
exit 0
Hi all,
I want to know how to send an email using shell script .....
I tried a command call mail but it did not work..
Please any one reply.. With example if you know thanks..
Madhu (4 Replies)
Hi All
i am writing a shell script which will search for a string "expires". once the search string is found it has to give the email address as the output and send an email to the person
This is basically to find the encrypetd keys which are loaded in the unix server
Below are sample... (10 Replies)
Hi,
Someone Knows how to obtein a chain from a unix file, but not all the line, for exemple, for this file ,obtein only 902111111 and to keep the value, this value will be used to make a mailx.
NF=ALL,
SUBJ=
FROM: SN=CD, SE=TOPCALL, NA=, N=902111111, N=TCLFI
TO: SE=FAX, NA=, C1=... (0 Replies)
hi,
i have to send an email once a day at ceratin time say 22.
i have tried with date commad, but not working.:(
HOUROFTHEDAY=`date +'%H'`
if ; then
mailx -s "Info" emailid@org.com < $ProcessStatisticsFile
fi
Please help me... (5 Replies)
Hi All,
I am new to the unix , i have to deliver one script very urgently
I have to write a shell script where i have i want to send email to specific email id
in this script i want
FROM to be parameterized and stored in a variable
TO to be parameterized and stored in a variable... (3 Replies)
Hello ,
I am trying to write a unix shell script to compare folder permission to say drwxr-x-wx and then send an email to my id in case the folders don't have the drwxr-x-wx permissions set for them .
I have been trying to come up with a script for few days now , pls help me:( (2 Replies)
Hi Friends,
Could you guys help me out of this problem... I need to send an email to all the users and the email has to be picked from the text file.
text file contains the no. of records like:
giridhar
224285
847333
giridhar276@gmail.com
ramana
84849
33884
venkata.ramana@gmail.com... (6 Replies)
This is my below script which is working fine as it send only plain text email.
So My question is- How can I modify my below script to send this as an HTML formatted email? I want to show the text color of this expression `(echo "100*$TEST2/$TEST1" | bc -l)` as `RED` in an email and that can be... (3 Replies)
Hello Experts,
Greeting to all of you.
I have a requirement, that we have a shell script status.sh
that check the status of server and server status shows as status.sh
Enterprise Server - Running
Admin Server - Shutdown
Requirement is like whenever the output shows shutdown it should... (2 Replies)
HI Team,
I am working on reading hive table and send email in email body using shell script, can you please help on fixing the errors: I have 6 columns in my hive table and trying to send the email in the mail body.
below script:
#!/bin/bash
hive -e 'SELECT count(*) from db.table' >... (4 Replies)
Discussion started by: Mi4304
4 Replies
LEARN ABOUT MOJAVE
shlock
SHLOCK(1) BSD General Commands Manual SHLOCK(1)NAME
shlock -- create or verify a lock file for shell scripts
SYNOPSIS
shlock [-du] [-p PID] -f lockfile
DESCRIPTION
The shlock command can create or verify a lock file on behalf of a shell or other script program. When it attempts to create a lock file, if
one already exists, shlock verifies that it is or is not valid. If valid, shlock will exit with a non-zero exit code. If invalid, shlock
will remove the lock file, and create a new one.
shlock uses the link(2) system call to make the final target lock file, which is an atomic operation (i.e. "dot locking", so named for this
mechanism's original use for locking system mailboxes). It puts the process ID ("PID") from the command line into the requested lock file.
shlock verifies that an extant lock file is still valid by using kill(2) with a zero signal to check for the existence of the process that
holds the lock.
The -d option causes shlock to be verbose about what it is doing.
The -f argument with lockfile is always required.
The -p option with PID is given when the program is to create a lock file; when absent, shlock will simply check for the validity of the lock
file.
The -u option causes shlock to read and write the PID as a binary pid_t, instead of as ASCII, to be compatible with the locks created by
UUCP.
EXIT STATUS
A zero exit code indicates a valid lock file.
EXAMPLES
BOURNE SHELL
#!/bin/sh
lckfile=/tmp/foo.lock
if shlock -f ${lckfile} -p $$
then
# do what required the lock
rm ${lckfile}
else
echo Lock ${lckfile} already held by `cat ${lckfile}`
fi
C SHELL
#!/bin/csh -f
set lckfile=/tmp/foo.lock
shlock -f ${lckfile} -p $$
if ($status == 0) then
# do what required the lock
rm ${lckfile}
else
echo Lock ${lckfile} already held by `cat ${lckfile}`
endif
The examples assume that the file system where the lock file is to be created is writable by the user, and has space available.
HISTORY
shlock was written for the first Network News Transfer Protocol (NNTP) software distribution, released in March 1986. The algorithm was sug-
gested by Peter Honeyman, from work he did on HoneyDanBer UUCP.
AUTHORS
Erik E. Fair <fair@clock.org>
BUGS
Does not work on NFS or other network file system on different systems because the disparate systems have disjoint PID spaces.
Cannot handle the case where a lock file was not deleted, the process that created it has exited, and the system has created a new process
with the same PID as in the dead lock file. The lock file will appear to be valid even though the process is unrelated to the one that cre-
ated the lock in the first place. Always remove your lock files after you're done.
BSD June 29, 1997 BSD