Hi all,

I have a main script (called OracleCleanup) that runs some sql queries. that runs off a wrapper script which contains the sources for the login information and and JOB_HOME (the script is below). When I schedule this job in the cron the log says that it cannot open my list file, which is located in somefolder. If i run this script manually by simply invoking it, it runs without any issues. Any ideas?

#!/bin/ksh

# Source appropriate login information
. $HOME/somefolder/login_Cleanup.ksh

# Set the JOB_HOME (ie. where the lists of tables to archive are held)
export JOB_HOME=/home/oracle/somefolder

# Run the job.
$HOME/somefolder/OracleCleanup.ksh

# Rename logfile
mv $HOME/somefolder/log/OracleCleanup.log $HOME/chris/log/OracleCleanup.`date +%m_%d_
%Y`.log