Re: UNIX Scripts Run In Cron

sheltra@emh-1.submepp.navy.mil wrote: > > I am running Informix 4gl and SQL programs in a script via a cron. The > job appears to be running properly with no aborts etc....however, when > I examine the Data Base and Tables that were to have been dropped and > recreated, I find that the status for the tables has not changed. The > SQL that drops the tables is written within the 4gl programs. When I > run the 4gl programs separately from the command line it works fine. Have you checked mail. If any errors are output during a cron program they generally go to mail, unless you are supressing them. Remember that cron runs with NO ENVIRONMENT. So do your programs set environment variables like INFORMIXDIR and PATH? Hope that helps, -- Mark. +-------------------------------------------------------------------------+ |Mark D. Stock - The West Solutions Group http://www.west.co.za | | | |mailto:marks@west.co.za +------------------------------------------------+ |Tel: +27 11 803 2151 |If it doesn't work... force it! | |Fax: +27 11 803 2189 |If it breaks... it needed replacing anyway! | |Cell: +27 83 250 2325 |Well, that's how I code anyway! | +------------------------+------------------------------------------------+