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 :(
Received on Mon Apr 04 2005 - 17:48:16 CDT
