Hello All,

One of my shell scripts was working fine till a few days back. It was scheduled in the cron. But yesterday i made some modifications to the script. The script works fine when i run it from the prompt. But it is not working when in runs from cron. Can someone help me out from this.

Hi,

There're many reasons for that to happen... it can simply be some command that's not in the PATH when running from cron... to avoid this, always use the full path to the commands...
Try to redirect the output to some file and then see the results...

If the cron job produces any output to stdout or stderr, it will email the output to the user that the job runs as. Have you checked for mail output? It may provide a hint to the problem.

Cheers,
Keith

Try this:

If your platform is solaris, restart the cron daemon as follows:
/etc/rc2.d/S75cron stop
/etc/rc2.d/S75cron start

If your platform is HP, restart the cron daemon as follows:
/sbin/rc2.d/S730cron stop
/sbin/rc2.d/S730cron start

*Remember your system may has different number of the script. eg. S70cron etc.
simply type "grep -i cron *" in the path to find which script for stop/start cron daemon.

Hope it help.

__________________
tikual :)

Thanks buddies,

Actually the ORACLE HOME path was set wrong in a profile file called by my program. I was connecting to a different instance of the database in the new script.

Thanks guys,
Raiden.