Hi...
I'm trying to run this script by using cronjob but it doesnt work. The purpose of this script is to monitor my oracle database partition when the size is less than 1gb, the script will trigger an email to my email address to alert about partition size
-------------------------------------------------------------------------
check_filesystem_size.ksh
-------------------------------------------------------------------------
#!/bin/ksh

for i in `df -k|grep /u0|awk '{ print $4 }'`
do
# Convert the file size to a numeric value
filesize=`expr i`

# If any filesystem has less than 1000k, issue an alert
if [ $filesize -lt 1000 ]
then
mailx -s "Oracle filesystem $i has less than 1000k free."\
adzuan@nc.com.my
fi
done
----------------------------------------------------------------------

Crontab line:

0 0 * * * /ek_ora/script/check_filesystem_size.ksh > dev/null >&1

----------------------------------------------------------------------

The error from /var/mail/oracle

Your "cron" job on jupm-wp11
/ek_ora/script/check_oracle_filesystem.ksh > /dev/null >&1

produced the following output:

sh: /ek_ora/script/check_oracle_filesystem.ksh: not found
-----------------------------------------------------------------------

Can anybody tell me why the script doesnt work??

run the script with "set -xv" and post the output.

one thing can be "expr $i"...

hi Duke
i changed to expr $i
i run the script like this :
----------------------------------------
bash-3.00$ set -xv
bash-3.00$ ./check_oracle_filesystem.ksh
./check_oracle_filesystem.ksh
+ ./check_oracle_filesystem.ksh
----------------------------------------

it just hung....

... well, the logfile is telling you the error:

sh: /ek_ora/script/check_oracle_filesystem.ksh: not found

0 0 * * * /ek_ora/script/check_filesystem_size.ksh > dev/null >&1

Hi There
Yeah my bad at the crontab
I just change the value to the right file name at the crontab
But although i run manually, still got error:

----------------------------------------------------------------------
-bash-3.00$ sh -x ./ek_ora/script/check_oracle_filesystem.ksh > a.out
+ + df -k
awk { print $4 }
+ grep /ek_
+ expr 0
filesize=0
+ [ 0 -lt 100 ]
+ mailx -s Oracle filesystem 0 has less than 100k free. adzuan@nc.com.my
---------------------------------------------------------------------

The script is just hung there....

Could it be something related to mailx command

Are you able to run mailx command successfully?

With the format you're using for mailx, it will definately hang forever.
this format will "from command line" give you a new line, where you type in a message, and every newline will do the same, until you type in a . "dot"
then it will send all the text you typed in with the subject.

mailx expects a message of some sort, by default, not just a subject!

The correct format within a script is:

mailx -s "subject" email_address < FILENAME > /dev/null 2>&1
# or if you don't want to use a file
mailx -s "subject" email_address << EOD > /dev/null 2>&1
EOD