Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> how create query that automatically runs every 30 minutes and write time and result to the file

how create query that automatically runs every 30 minutes and write time and result to the file

From: Mike <mikepiter_at_yahoo.com>
Date: 7 Dec 2003 12:35:50 -0800
Message-ID: <95c0565.0312071235.10aa48be@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US