When you run the job manually, you'll be using all of the environment set up in your profile. When the job runs under cron, that profile's not there.
Three choices...
Source your profile in cron...
Quote:
55 * * * * ./<your_home_path/.profile; sh /oracle/statistics.sh > /dev/null 2>&1
Source your profile in the script
Quote:
./<your_home_path/.profile
/oracle/bin/svrmgrl << EOF
connect inventory/inventory;
set serveroutput on size 900000
.
.
Or just add the required environment variables to the script...
Quote:
export ENV_VARIABLE=<Path>
etc
.
.
/oracle/bin/svrmgrl << EOF
connect inventory/inventory;
set serveroutput on size 900000
.
.
HTH
Jerry