Crontab not sending mail , Crontab not running script

Hello ,

Today I am here to tell about the major problem which every one faced while configuring crontab.
We see our script running manually but through crontab it's not running properly.

There is only one solution to this problem i.e to add environment variables in your script.

For example -

Here is one file Test.sh. it contains following lines.

#!/bin/bash
sqlplus  /nolog  @/path/test.sql | mail -s "status" Saurabht904@gmail.com

Maually this script is running .

But when I tried to run through it crontab nothing was happening. I was getting blank mail only.

Then I added my environment variable on top of script.

Like this -

#!/bin/bash
export PATH=/home/oracle/product/11.2.0/OPatch:/usr/bin:/usr/local/bin:
/bin:/usr/bin:/export/home/oracle/bin:/export/home/oracle/product/bin:
/export/home/oracle/product/11.1.0
export ORACLE_BASE=/export/home/oracle
export ORACLE_HOME=/export/home/oracle/product/11.2.0
export ORACLE_SID=Test
sqlplus  /nolog  @/path/test.sql | mail -s "status" Saurabht904@gmail.com

This time my script is creating file and sending data through mail . :)


So always remember to set environment variable if your crontab is not working properly.


Thanks For Reading this Post.

You can write me mail on Saurabht904@gmail.com.....