I have a scheduled job on Oracle which does counts before and after delete statements and spools the results to a log file on the Oracle server. The job is type SQL_SCRIPT. When I execute the job the SQL statements are also included in the spool file even though I have specified SET TERM OFF ECHO OFF in the script.

My question is, how can I prevent the actual SQL statements from being included in the spool file when it is executed through the Oracle Job Scheduler?

I have tried various options and searched hundreds of articles but have not found anything on this particular issue.

Thanks
Derrick

my_script := 'conn user/pass@db
set termout off
set echo off
spool ...
select object_id, object_name from all_objects;
spool off';

my_script := '
#!/bin/bash
export PATH=...
export ORACLE_HOME=...
cat <<EOF > /tmp/myscript.sql
set termout off
set echo off
spool ...
select object_id, object_name from all_objects;
spool off
exit
EOF

sqlplus -s user/pass@db @/tmp/myscript.sql';