Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: how do you scheduled sql scripts

Re: how do you scheduled sql scripts

From: Doug Barnes dwb_at_rell.>
Date: 1997/10/02
Message-ID: <611be8$nrq@ux1005.rell.com>#1/1

Impala Media wrote:
>
> Apart from using a snapshot, is there a way of scheduling script or sql
> command execution??
>
> I would like to do appends to table B at a certain time during the night
> every day, if there is any data within table A.
>
> Thanks
>
> Os

What box are you on. You can fire off a sqlplus session easily from a cron job on a UNIX box. That how I do my hot backups (I use sqldba/sqlmgr instead but the concept is identical).

-- 
Remove the NOSPAM to E-mail me.  Tired of the MLM schemes.
Received on Thu Oct 02 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US