Hi all,
I had some problem with my cronjob, any way, below is the task that need to be execute :
ORACLE_SID=MYDATABASE
export ORACLE_SID
SDEHOME=/home/sde/sdeexe83
export SDEHOME
#compress the geodatabase
$SDEHOME/bin/sdeversion -o compress -i esri_sde -u sde -p sde
this task is saved as compress.sh and I did change the permission for everyone had the right to execute it. when I execute this job mannualy, it ran successfully. below is the snapshot of this job.
[sde@mycomputer MYDATABASE]$ ./compress.sh
ArcSDE 8.3 Build 284 Thu Jul 17 14:55:03 PDT 2003
Version Administration Utility
-----------------------------------------------------
Compress state tree: Are you sure? (Y/N): y
Successfully compressed state tree.
[sde@mycomputer MYDATABASE]$
when I put this job in the cronjob as follow
56 13 * * * cd /home/sde/stuffs/scripts/mydatabase && yes | /home/sde/stuffs/scripts/mydatabase/compress.sh
it never executed and I kept getting the error on the mail:
Subject: Cron <sde@mycomputer> cd /home/sde/stuffs/scripts/mydatabase && yes | /home/sde/stuffs/scripts/mydatabase/compress.sh
X-Cron-Env: <SHELL=/bin/sh>
X-Cron-Env: <HOME=/home/sde>
X-Cron-Env: <PATH=/usr/bin:/bin>
X-Cron-Env: <LOGNAME=sde>
/home/sde/sdeexe83/bin/sdeversion: error while loading shared libraries: libsde83.so: cannot open shared object file: No such file or directory
could someone please help???
