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

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Mon, 08 Dec 2003 08:58:33 -0800
Message-ID: <1070902749.762900@yasure>

Mike wrote:

>> Daniel Morgan <damorgan_at_x.washington.edu> wrote in message news:<1070833191.648908_at_yasure>...

>

>>Put the script into a procedure and run it with DBMS_JOB.

>
>
> Can you give me the example?
>
> Mike.

With writing stored procedures or using DBMS_JOB?

You can find both at http://tahiti.oracle.com. If, after writing the code, you have specific problems post your code and we will try to help.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Mon Dec 08 2003 - 10:58:33 CST