Re: Auto Loading data

I have a job run thru cron for loading data using onpload. Mine works fine and it has the related lines as follows: ## all the Informix envi. variables are set onpload -j $load_job -f 2>> $load_log >> $load_log ... ... I don't have any project defined, so I don't use the '-p' option. The difference is the redirection, which should not matter, I think. What exactly does the exit code 3 reflect in your script? Vijay R. Anisetti 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. > > Wanda Zeng, DBA email: zeng@wsu.edu > Information Technology FAX: (509) 335-0540 > Washington State University Phone: (509) 335-1697 > PO Box 641222 > Pullman, WA 99164-1222 -- ___________________ _____| Vijay |___ \\ | 'Bindas Dude' | / ) |___________________| ( /______) (____\\