| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: help. Need Sql script to run nightly.
We use a commercial package called AutoMate. Costs some $, but it is very flexible and user friendly.
On Thu, 09 Nov 2000 14:20:46 GMT, insomnia_at_cvzoom.net (Greg Akins) wrote:
>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! =-----
 |
 |