Informix Cron Job
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 -