Rauf Sarwar wrote:
> 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
>
that did the trick - thanks (never even thought of ":" being an illegal
part of a filename!)
Received on Tue Apr 05 2005 - 14:41:40 CDT
