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

Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl> wrote in message news:<r4r9tvo4udihm1qf5v05sfq31bjbjj5uug_at_4ax.com>...
> On 8 Dec 2003 12:26:40 -0800, mikepiter_at_yahoo.com (Mike) wrote:
>
> >Server should receive the select statement, send back the data to the
> >client, and then the same should be repeated after 30 minutes.
>
> Time again for you to use the gray cells which have been put to rest
> for a while.
> Look up the command SPOOL in sqlI*plus, and the at command in
> winblows.
> Other than that, I charge $100 per hour for doing your homework, you
> are too lazy to do yourself.

My dear very wise Senior Oracle DBA. Could you please go to message 1 in this
thread and read very very carefully this above-mentioned message 1. If you will
be patient enough to do this, than maybe you will find out that command SPOOL
and command at are already there. You didn't give any good advice so far besides fisting. Seems like this is the only area that you are good enough. Doubt that I want to pay $100 per hour for lessons in fishing.

Thanks. Mike. Received on Mon Dec 08 2003 - 22:13:46 CST