Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: how do you scheduled sql scripts
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