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:
.. but the crontab you posted says:
What's the actual name of the script?
What's actually in crontab?

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?

Hi csenewbie
First, i'm not very familiar with the mailx command either its right or not.
Kindly can u give me the right command in order to run mailx command successfully. I'll test this first.