Re: Informix Cron Job
Posted in 1998
Topics: Server Administration
If that's all in your cronfile, I'm absolutely sure, zhat it won't work.
INFORMIX never runs without the proper environment, which must contain at
least a valid INFORMIXDIR and INFORMIXSERVER.
cron is started at system boot time, which means. that it has it's own
(crippled) environment, which includes a minimum of PATH, TIMEZONE and I
guess a USER or LOGNAME root. It might be possible to add a
PATH=$PATH:$INFORMIXDIR/bin ; export PATH to your shell script.
0410168790-0001@t-online.de schrieb im Beitrag
<6hpu46$dj6$1@news02.btx.dtag.de>...
> norli <norli@asiapac.net> schreibt: > 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