Re: cron jobs

joshua@tulsa.oklahoma.net wrote: > > Have included as much info as possible. We are unable to run this job > "ship" successfully.. It runs otherwise. > Unsucessfully?, otherwise? You didn't include the most important info possible What are the specific error messages? What operating system/version? What Informix database type/version? MB > Any help is appreciated.. joshua > > # spinner rack 1 > #05 17 * * 1,2,3,4,5 /usr4040/mis/mis_edc/progs/spin1.sh > # spinner rack 2 > #07 17 * * 1,2,3,4,5 /usr4040/mis/mis_edc/progs/spin2.sh > # ups unload > 45 * * * * /usr4040/mis/mis_edc/progs/ship.sh > ********************************************************* > TMPDIR=/dbtemp ;export TMPDIR > > LANG=C ;export LANG > > SRC=/usr4040/mis/mis_csrc ;export SRC > > MATHLIB=/lib ;export MATHLIB > > NLSPATH=/usr/lib/nls/msg/%L/%N:/usr/lib/nls/msg/prime/%N ;export > NLSPATH > MISDOC=/usr4040/mis/mis_doc ;export MISDOC > > DBTEMP=/dbtemp ;export MISDOC > > DEPTH=1 ;export DEPTH > > USRLIB=/usr/lib ;export USRLIB > > MENU=/usr4040/mis/utils ;export MENU > > PATH=/usr/local/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:/home/cmw/bin:/usr/bin/X11:> /sbin:/misc/bin:/misc/etc:/udms:/udms/etc:/usr4047/wp/wpbin:/usr4047/wp/shbin:/i > nformix5/bin:/u/orchid:/informix5/bin:/usr/mis/bin:/usr4040/mis/changes:/usr4040 > /mis/utils:/usr4040/faxfx/bin ;export PATH > > DBASE_NAME=mis_db.dbs ;export DBASE_NAME > > UTILS=/usr4040/mis/utils ;export UTILS > > DBPATH=/usr4040/edc ;export DBPATH> > CDPATH=:..:/usr4040/mis/mis_all:/usr4040/mis/mis_po:/usr4040/mis/mis_oe:/usr4040 > /mis/mis_csrc:/usr4040/mis/mis_ar:/usr4040/mis/mis_ic:/usr4040/mis/mis_sa:/usr40 > 40/mis/mis_doc:/usr4040/edc ;export CDPATH > > CSRC=/usr4040/mis ;export CSRC > > SUPPORTPROGS=/usr4040/mis/mis_214 ;export SUPPORTPROGS > > MISTERMDEF=/usr4040/mis/utils/mistermdef ;export MISTERMDEF > > EDITOR=vi ;export EDITOR > LOGNAME=cmw ;export LOGNAME > SPLPATH=/usr/lpd/qconfig ;export SPLPATH > AIXSPLPATH=/usr/lpd/pio/custom ;export AIXSPLPATH > MAIL=/usr/spool/mail/cmw ;export MAIL > HOSTNAME=prod1 ;export HOSTNAME > LOCPATH=/usr/lib/nls/loc ;export LOCPATH > #PS1=[${HOSTNAME}:${PWD}]-!> ;export PS1 > INFORMIXVER=2.0 ;export INFORMIXVER> #APPL_NAME=Next Generation ;export APPL_NAME > MALOC=-lc ;export MALOC > TERMCAP=/usr4040/mis/utils/termcap ;export TERMCAP > USER=cmw ;export USER > MISINC=/usr4040/mis/include ;export MISINC > MISPGM=osm ;export MISPGM > SYSTEM=AIX ;export SYSTEM > GSDB=g ;export GSDB > MALLIB=/usr/lib ;export MALLIB > SHELL=/bin/ksh ;export SHELL > ODMDIR=/etc/objrepos ;export ODMDIR > INFORMIXTERM=/usr4040/mis/utils/terminfo.ibm ;export INFORMIXTERM> SQLFORMS=/usr4040/mis ;export SQLFORMS > #DBPRINT=lp -dlp1 ;export DBPRINT > MALLOC_LIB=/lib/libc.a ;export MALLOC_LIB > HOME=/home/cmw ;export HOME > INCLUDE=/usr/include ;export INCLUDE > INFORMIXDIR=/informix5 ;export INFORMIXDIR> GROUPNAME=system ;export GROUPNAME > TERM=wyse50 ;export TERM > #MAILMSG=[YOU HAVE NEW MAIL] ;export MAILMSG > #CFLAGS=-c -g -DAIX ;export CFLAGS > PWD=/dbtemp ;export PWD > TERMINFO=/usr4040/mis/utils/terminfo.ibm ;export TERMINFO > PSTATUS=/usr/lpd/qstatus ;export PSTATUS > TZ=CST6CDT ;export TZ > LPDEST=lp1 ;export LPDEST > WPTERM51=wyse50 ;export WPTERM51 > #CC2_FLAGS=-g -DAIX ;export CC2_FLAGS > APPL=usr4040 ;export APPL > CRONLOC=/usr/spool/cron/crontabs ;export CRONLOC > A__z=! LOGNAME="*TMOUT ;export A__z LOGNAME > isql -q mis_db -cr /usr4040/mis/sqlforms/ship > ********************************************************* > > unload to "/tmp/transfer/ship.csv"> > select ordnum_ordera,shipattn_ordera,shipname_ordera,shipadr1_ordera,> > shipadr2_ordera,shipadr3_ordera,shipcity_ordera,shipstate_ordera, > > shipzip_ordera,"1" from ordera > > where ordnum_ordera not in (select unique ordernum_ordinpro from > ordinpro) > order by 3