Re: how do you scheduled sql scripts

If what you need can be written as a PL/SQL procedure, then the best thing to do is to create the procedure and use the built-in packaged procedure "DBMS_JOBS" which can schedule the execution of you procedure no matter what operating system you are using (Similar to what UNIX cron can do at the O/S level)

 Ammar Sajdi
palco_at_go.com.jo

Doug Barnes <dwb_at_rell. <"NOSPAMcom> wrote in article <611be8$nrq_at_ux1005.rell.com>...
> 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 Fri Oct 03 1997 - 00:00:00 CEST