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

Mike wrote:

> Dear Senior Oracle DBA!
> I am glad that finally you read message 1. But you are still not
> accurate.
> I asked you not just to read but read it carefully. If you do so then
> you notice the at command. Although you are definitely making progress
> in finding spool command. Here is a hint: go to message1 in this
> thread and find
> line 11 starting from Hi as line 1. If you follow these directions
> then you find the command at between commands SPOOL and SPOOL OF. If
> you don't, then we have a problem here more serious than my question.
>
> Thanks. Mike

It may be worth noting that the "AT" command is part of the scheduler (or is the scheduler?) on Windows. You seem to be referring to the SQL*Plus command "@", which is used to run scripts, and not the actual "AT" executable. Not sure if this helps, though. Received on Tue Dec 09 2003 - 11:28:45 CST