Shell Programming and Scripting

Hi All!

I have a problem with one of my scripts. When I run the script from the command line : ./myscript.mac, it runs fine, but when I schedule it to run as a cronjob I get the following error :

-----------------------------------------------------------------------------
Your "cron" job on cssp4
/d2/scripts/myscript.mac > /dev/null
produced the following output:

/d2/scripts/myscript.mac: does: cannot open
-----------------------------------------

All the script does is call a .sql file that checks for invalid objects in the database. Why can I run it from the command prompt but not via crontab?

Thnx!

If your script is running from the command line, but failing via cron, and it complains of not finding/being able to open something it might be due to an undefined variable.

Ensure you are declaring all the variables in the script that it needs, where it not running in a login shell. Take a look at the variables set as part of your login shell and if some of them are used by the script, make sure you have declared them in it.

Also the PATH can be different from the cron and the command line

All the enviroment variables for the 'user' Cron (not a real user but a 'pretend' user that runs the scheduled tasks) could be differnet to the user who owns the script.


Does it run ok when you use /d2/scripts/myscript.mac ?

Please check the path and still if u find the same problem

go to the prompt and type

cron -e

this opens an cron editor in that set the job and write quit before getting in to these operations check the permissions of the file myscript.mac (it should have the read and execute permissions)
Hope this will solve the problem

i have the same sorta thing going on here.

i have a cron job that executes some sql files.

Code:

hostname:/scripts# ls -l riv-data.ksh
-rwxr-xr-x   1 username group      306 Aug 13 08:50 riv-da
hostname:/scripts# cat riv-data.ksh
. /execute/users/environment/here
cd /path/to/sql/files
/usr/informix/bin/isql -s standard inventory.sql
/usr/informix/bin/isql -s standard inventoryLOT.sql
/usr/informix/bin/isql -s standard orderdetails.sql
/usr/informix/bin/isql -s standard orderheaders.sql
/usr/informix/bin/isql -s standard whse.sql

from what it sounds like you have the word "does" somewhere in your script. find it and take a look at what you are trying to do.