Re: how do you scheduled sql scripts
From: Doug Barnes <dwb_at_rell. <dwb_at_rell.">
Date: 1997/10/02
Message-ID: <611be8$nrq_at_ux1005.rell.com>#1/1
Date: 1997/10/02
Message-ID: <611be8$nrq_at_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 CEST