Re: help. Need Sql script to run nightly.

Or you could write a stored procedure and schedule the job via the dbms_job package.

-greg

On Thu, 09 Nov 2000 05:49:40 GMT, Jerry Gitomer <jgitomer_at_erols.com> wrote:

>
>
>>>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<<
>
>On 11/8/00, 6:07:03 PM, jane_ballard_at_my-deja.com wrote regarding help.=20
>Need Sql script to run nightly.:
>
>
>> Hello all,
 

>> Is there a way to have sqlplus execute a select statement to
>> export the data set out on a nightly basis. The select condition
>> changes daily however the columns selected does not.
 

>> Is there a way to automate this? I'm on NT, oracle 8.0.5.
 

>> Thanks in advance for any help. I've tried a few things. It
>> didn't work.
 

>> Jane
>
>
>> Sent via Deja.com http://www.deja.com/
>> Before you buy.
>
> Set up an AT command to invoke a sqlplus script stored in=20
><drive>:\orant\bin
>
>

-----= Posted via Newsfeeds.Com, Uncensored Usenet News =----- http://www.newsfeeds.com - The #1 Newsgroup Service in the World! -----== Over 80,000 Newsgroups - 16 Different Servers! =----- Received on Thu Nov 09 2000 - 08:20:46 CST