Re: cron job (SCO) and INFORMIX

Kate, There are a couple of things you might try. First, who is the cron job running as? That is, who was the job submitted under (informix, root, etc.). Are you sure that person has execute privilege to the dbaccess, etc. programs? You might also try adding some debug statements to you cron script. For example: echo $PATH >> /tmp/cron.dbg whence dbaccess >> /tmp/cron.dbg id >> /tmp/cron.dbg dbaccess pic xxx >> /tmp/cron.dbg ...and so on... Hopefully, something here will help narrow down your problem. Please feel free to e-mail me direct if you're still stuck or if something in your debug looks fishy. --Craig (craig@chemistry.utah.edu) > > I need to run a shell script that calls dbaccess, sacego and ISQL. I've > set it up so that it sets all the environment variables and the path, yet > I still get an error from cron that the executables can't be found. My > script is of the form > > SET INFORMIXSERVER mecho_s; export INFORMIXSERVER > etc. etc. > > dbaccess pic xxx > ISQL xxx >