#REM ============================================================
#REM Description: This Shell script program accepts request_id, email and Subject as argument
#REM and Send email with attachment of output file for the request
#REM=============================================================
echo "Current Request :" $4
echo "Output Request :"$5
echo "Email :"$6
echo "Email Subject :"$7
fname=`sqlplus -s $1 <
set feedback off
set verify off
select outfile_name from fnd_concurrent_requests
where request_id = $5
/
xxxEOFxxx`
echo "File name from SQL :"$fname
fname=`ls $fname`
echo "Actual file name :" $fname
if [ -z "$fname" ]
then
echo "No request matching id $5"
elif [ -s $fname ]
then
echo "Getting output file: $fname"
echo "Sending Email to :" $6
/usr/bin/uuencode $fname "$5.out" | mailx -s "$7" $6
else
echo "Either file $fname does not exist or it is of 0 bytes"
fi
No comments:
Post a Comment
Note: Only a member of this blog may post a comment.