Re: Informix Cron Job

This is a multi-part message in MIME format. --------------1FC9D9F8B93D692E28CA19DA Content-Type: text/plain; charset=us-ascii Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Content-Transfer-Encoding: 7bit Presumeably, you are missing some environment variables. Do an env command at your command prompt and write a line like 'env > env.out' in the shell script that you invoke through cron. Compare the two outputs. Look for variables like INFORMIXDIR, INFORMIXSERVER and PATH (which should include $INFORMIXDIR/bin) best regards claus norli 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: > > #!/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 - --------------1FC9D9F8B93D692E28CA19DA Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Claus Samuelsen Content-Disposition: attachment; filename="vcard.vcf" begin: vcard fn: Claus Samuelsen n: Samuelsen;Claus org: Sysdeco Danmark A/S adr: Gydevang 22 B;;;DK-3450 Aller'd;;;Denmark email;internet: csa@sysdeco.dk title: Systems Manager tel;work: +45 4814 3000 tel;fax: +45 4814 3011 x-mozilla-cpt: ;0 x-mozilla-html: FALSE end: vcard --------------1FC9D9F8B93D692E28CA19DA--