Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> how create query that automatically runs every 30 minutes and write time and result to the file
Hi,
I run a Script File from the sql plus on the win 2000 client machine
against the Oracle server v.8i that resides on the different machine:
Script File is located on the client machine in the file
c:\query_1.sql
The content of the file is the following:
select count(*), host_updated from jtrans_header
where trans_date='7-dec-2003'group by host_updated'
In SQL*PLUS, I type the following:
SPOOL c:\query_result
@c:\query_1.sql
SPOOL OFF
I want to run this script automatically every 30 minutes during 3
hours period
and write the response time to the file as well as the system time
that the query was executed.
Thanks. Mike. Received on Sun Dec 07 2003 - 14:35:50 CST