UNIX for Dummies Questions & Answers

Buddies, cron is not executing any monitoring scripts for 'Oracle' user in Red Hat Linux 5.
Details about the cron job :-

Code:

oracle@localhost ~]$ crontab -l
 15  7  * * * /home/oracle/tab.sh

The tab.sh script when firing manually is working fine.

Any inputs/advice will be great for me.

What's the error message? Errors will get e-mailed to the login name of the process running the cron job. Hopefully the shell script you are running is writing to a log for even more info. At any rate, the Oracle environment needs to be set inside the script itself. When you are running from the command line, your environment most likely already has ORACLE_HOME, ORACLE_SID, etc set in your .profile so it works fine from there. Set them at the top of your script and try it again.

How can I get the error messages for the cronjob ? My scripts begins with setup of Oracle Environment, so that's not a challenge, correct me if I am wrong. The output of the script file is written to another log file which is not generating by which I determined that cronjob is not working, but when I am running the script manually instead of cronjob, it is working fine. What other troubleshooting can I do under this scenario? Any advice /inputs will be highly appreciated.

Did you not read this recent thread that explains it all:
https://www.unix.com/unix-dummies-que...tab-entry.html

If you search the forum you will find many posts on the subject

Start by redirecting STDIN and STDOUT to some files in a directory writeable by you...
Cron has a log file, look in it for some information, on AIX and HP-UY you will find a /var/adm/cron directory with a log file... in RH5 I have no idea, somewhere in /var/log?
Then as Gary mentionned, you should have a message in your mbox about cron - What does it say?

Here what I got from cron log

Code:

Jun  5 07:25:02 localhost crond[10934]: (root) CMD (/home/oracle/tab.sh)
Jun  5 07:27:34 localhost crontab[10950]: (oracle) LIST (oracle)
Jun  5 07:30:01 localhost crond[11021]: (root) CMD (/usr/lib/sa/sa1 1 1)
Jun  5 07:40:01 localhost crond[11140]: (root) CMD (/usr/lib/sa/sa1 1 1)

Any further things which I need to check more

Thanks once again for the great assistance !

Also search for more lines in your cron log matching PID 10934 . There should be a line with a result code ... unless the script hangs.

Anything in unix mail for account "oracle" or account "root" ?


Strange discrepancy between the scheduled time from crontab and the entry in the log.