Re: how do you scheduled sql scripts

the jobs can be scheduled using DBMS_JOB package. Each job is a call to a stored procedure.

refer to PL/SQL manual for DBMS_JOB package.

let me know if this helped.

Chinna

Christian.Spirig <Christian.Spirig_at_email.leica.com> wrote in article <343CA364.5466_at_email.leica.com>...
> scheduling an sql-command:
>
> 1) that shoud be possible with oracle enterprise manager
> 2) you could run sqlplus in batch and schedule that with os-commands
> like the at-command at Windows NT
>
> Chris
>
> 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
>
Received on Tue Oct 14 1997 - 00:00:00 CDT