Hi All,
Am having a shell script JDE_REPORT_GEN.sh which intern calls a sql script JDE_CHANGED_DATA.sql. the problem here is when i run this script from the $prompt it is running fine and giving out the spool file required.

if i schedule the same shell in cronjob am not getting the spool file.Please advice this is very urgent and the content of the script is as below.
#################################
$cat JDE_REPORT_GEN.sh
#!/bin/sh

cd /tmp/azum

ORACLE_HOME=/asera/app/oracle/product/10.2.0/db_1
export ORACLE_HOME

sqlplus manta/manta@MTACS3 <<VITMAN @/tmp/azum/JDE_CHANGED_DATA.sql
exit
VITMAN
#######################################
$ cat JDE_CHANGED_DATA.sql
set echo off pagesize 49000 head off feed off veri off trimspool on
set linesize 30000
spool /tmp/azum/JDE_DATA_CHG_QTY_DUMMY_REPORT.csv

*****sql query here******

spool off;

##########################################


a prompt response to this is much appriciated.

thanks in agvance,
Azum.