On Feb 24, 12:07 pm, imalukegal <dgre...@centene.com> wrote: > One more thing, I did try 'set term off' and that did not suppress > the output from going to the job's standard list either. > > Donna > > On Feb 24, 12:44 pm, imalukegal <dgre...@centene.com> wrote: > > > > > I am executing sql within a unix script. I am spooling the output to > > a file; however, the spooling contents is also going to the standard > > list for the job. How can I suppress this from occurring? My > > standard list is huge as I am extractring 180,000 members. Below are > > the options that I am currently using. What other command will > > prevent the results from going to the job's standard list? > > > set autotrace off > > set echo off > > set feedback off > > set heading off > > set term on > > set verify off > > set linesize 50 > > set pagesize 0 > > > Thanks for any help. > > > Donna- Hide quoted text - > > - Show quoted text -
It proably won't as I have never been able to supress the output from a cron job to the mailer daemon. Running the script from the SQL> prompt will probably produce the lack of output you desire; cron is a different environment and sometimes doesn't behave as you'd like it to. Simply keep up with the local account mail and clear it out on a weekly basis. David Fitzjarrell -- You received this message because you are subscribed to the Google Groups "Oracle PL/SQL" group. To post to this group, send email to Oracle-PLSQL@googlegroups.com To unsubscribe from this group, send email to oracle-plsql-unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/Oracle-PLSQL?hl=en
