Try to set a oracle cron job on AIX 5.2

From: <philchan_at_rogers.com>
Date: 19 Mar 2007 13:33:20 -0700
Message-ID: <1174336400.261141.70360@y66g2000hsf.googlegroups.com>

Hi,

   I am trying to set up a cron job to backup my database daily, the following is my shell script, but it
seems it would not run from the cron, but the manual run is fine, I don't know what is missing from my environment:

---

#!/usr/bin/ksh
#oracle daily backups

export ORACLE_SID=MYPRD
export ORACLE_HOME=/home/app/oracle/product/9.2.0
export ORAENV_ASK=NO;

. oraenv

WORK_IDEN=/san01/pmmprd/alcprd/exp/exp_myprd_full

exp system/manager file=$WORK_IDEN.dmp log=$WORK_IDEN.log full=y direct=y
exp system/manager parfile=$WORK_IDEN.par ~

---

Any suggestion is appreciated.

Philip Received on Mon Mar 19 2007 - 15:33:20 CDT