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

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

From: Mike <mikepiter_at_yahoo.com>
Date: 8 Dec 2003 12:26:40 -0800
Message-ID: <95c0565.0312081226.3aefdde6@posting.google.com>

Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl> wrote in message news:<ii38tvoalqtbia83thvruh7kppienuqggp_at_4ax.com>...
> On 7 Dec 2003 18:46:03 -0800, mikepiter_at_yahoo.com (Mike) wrote:
>
> >Can you give me the example?
>
> You can do that yourself with a litttle bit of effort yourself.
> This group is about learning people to fish, not to do their fishing.

From my learning efforts, it looks like DBMS_JOB runs on the server when initiated. If you were careful enough reading my question rather than exercising yourself in fishing, I don't have to run it on the server.
Server should receive the select statement, send back the data to the client, and then the same should be repeated after 30 minutes.

Thanks. Mike. Received on Mon Dec 08 2003 - 14:26:40 CST