Re: Auto Loading data

Y Wanda Zeng wrote: > > I want to have my loading jobs to run at regularly scheduled time using > "onpload -p projectname -j jobname -fl". I created a sh script which has > Informix env variables setting and all the commands. The sh script runs well > manually, but failed when I used crontab to run at scheduled time. The > return code is 3. My question is how do I run the Informix command using > UNIX utilities automatically. Any help is very appreciate. > While I'm unfamiliar with the return code error, I'd check the environment variable listing. Does the user running the onpload have permission? Are you calling the job from a shell script? One thing that we had to remember was that cron (HPUX10.01) has little knowledge of the environment. We made sure that all jobs were run from shells that had all relevant environment variables set. Hope this helps John Carlson