Re: Informix Cron Job

Probably your environment variables are not being get. When a cron job starts the user's .profile doesn't get executed, so vital variables such as $INFORMIXDIR and $PATH are not being set up. Neil Truby Chase Manhattan Bank Bournemouth, UK In article <354056BD.C1AADB44@asiapac.net>, norli says... > >Hi all, > >Is there a way I can schedule some processes: > >1. update table, on UNIX, via cron job? > >I created a cron under user informix to update a table monthly. My cron >entry: > >1 0 1 * * /export/home/intranet/leave_app/annual_update >/dev/null 2>&1 > >My annual_update file: > >#!/bin/csh > >cd /export/home/users/norli/leave_app > >dbaccess intranet annual_update.sql > > >My annual_update.sql file: > >#!/bin/csh > >update employee set annual=annual+1> > > >If I run annual_update from the command prompt, it works. But not from >the cron job call. Any idea why? Really need some help... Thanks! > >- norli - >