Re: why cant I spool <filename> with a variable?

GS wrote:
> Rauf Sarwar wrote:
> > GS wrote:
> >
> >>I know I have done this before, but I dont know why this is not
> >
> > working
> >
> >>and I cant find my old script where I did this, perhaps someone
here
> >
> > can
> >
> >>point out the obvious for me...
> >>
> >>I want to run a script every X minutes for awhile tomorrow morning
> >
> > for
> >
> >>about 1 hour, and I want the output spooled to a file with a
> >
> > timestamp,
> >
> >>simple enough so I write the following script called log_usage.sql:
> >>
> >>====================================================
> >>col TS noprint new_value TS
> >>select to_char(sysdate,'hh24:mi:ss') TS from DUAL;
> >>
> >>spool &TS.log;
> >>@@temp_usage.sql;
> >>spool off;
> >>====================================================
> >>
> >>I keep getting the "SP2-0332 cannot create spool" file error, not a
> >>matter of permissions etc as I can spool to a file fine without the
> >>variable (this is a windows machine as well)
> >>
> >>
> >>what am I missing here?
> >>
> >>TIA
> >
> >
> > 1) You are using an illegal character ":" to name a file. Change
select
> > to,
> > select to_char(sysdate,'hh24miss') TS from DUAL;
> >
> > 2) Always put an extra . when using replacement variable with a .
like
> > &TS..log. &TS.log will work but your filename will come out as e.g.
> > 999999log.lst.
> >
> > Regards
> > /Rauf
> >
> ok, that works, but it appears I have to use my linux box in any
case,
> as a quick look at windows scheduler doesnt seem to have a setting
for a
> job to run every X minutes :(

Create your job to run daily e.g. at 10:00pm. Once the job is created, Right Click on it and goto Properties --> Schedule --> Advanced then choose your times in "Repeat Task".

Regards
/Rauf Received on Mon Apr 04 2005 - 18:08:47 CDT