Basically, this is unix standard I/O feature and there are ways to suppress command output to get printed on Standard Output.
The very basic way of doing it is "your_unix_command >> new_file.txt", there are many ways of doing it. Try some unix forum to have your answer. Regards, Sonty On Feb 26, 6:34 am, ddf <orat...@msn.com> wrote: > 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
