Re: Scheduler to execute a procedure

San LUC <san_at_a2c.fr> wrote in article <36404695.7C392CBA_at_a2c.fr>...
>
>
> Hi,
>
> Does anyone know how I can tell Oracle to execute a procedure everyday
> at 1200AM ?
>
> Thank
>
>

USE PACKAGE DBMS_JOB

 PROCEDURE submit    ( job       OUT BINARY_INTEGER,
                        what      IN  VARCHAR2,
                        next_date IN  DATE DEFAULT sysdate,
                        interval  IN  VARCHAR2 DEFAULT 'null',
                        no_parse  IN  BOOLEAN DEFAULT FALSE);

• Submit a new job. Chooses JOB from the sequence sys.jobseq.