Re: Informix Cron Job

In article <354056BD.C1AADB44@asiapac.net>, norli <norli@asiapac.net> wrote: > > 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: Norli: I have had this problem, Everything I tried just didn't work. I finally put added to my cron job: su - informix <program name> as the command. This works for me all the time now. > > #!/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 - > > -----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading