Re: SPOOL INTO A JOB
Date: Sat, 06 Sep 2008 00:24:43 +0200
Message-ID: <fbc3c4lm09ej7eus3ql3evl42tdcrrtgsk@4ax.com>
On Fri, 5 Sep 2008 12:36:00 -0700 (PDT), CenturionX
<darwinbaldrich_at_gmail.com> wrote:
>Hello everybody,
>
>I'm working with Oracle 10g.
>I have a report generated by a sql script. This script runs in a
>windows task.
>I have to generate this report from the database now.
>The report like that (I modified it for confidential issues):
>set feedback off
>set pages 50
>set lines 80
>
>COL TIMESTAMP NEW_VALUE xTIMESTAMP noprint format a1 trunc
>COL BAR FORM a7 HEADING 'BAR'
>COL COMPONENT FORM a15 heading 'COMPONENT'
>COL AGGBALANCE heading 'AGG. BALANCE'
>
>break on BAR skip 1
>
>ttitle center 'MY REPORT' skip 1-
> center '====================================' skip 2
>btitle left ' ' skip 2 -
> left 'Time of Report: ' xTIMESTAMP skip 2 -
> center 'Page: ' format 999 SQL.PNO
>spool D:\Reports\reportname.txt
>
>SELECT sysdate from dual
>/
>spool off
>btitle off
>ttitle off
>clear breaks
>clear computes
>clear columns
>
>
>My question is if i can run that script like this from a job.
>
>Thanks.
Yes, obviously.
Next question to be expected 'How'
My answer: You didn't ask that. Also you didn't specify an exact
version and a platform.
-- Sybrand Bakker Senior Oracle DBAReceived on Fri Sep 05 2008 - 17:24:43 CDT