Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: DBMS_JOBS problem

Re: DBMS_JOBS problem

From: RS <rs_at_rshome.u-net.com>
Date: Fri, 2 Feb 2001 23:07:43 -0000
Message-ID: <84He6.772$i54.980141@newsr1.u-net.net>

Thanks, it worked.

Jeremy Ovenden <jovenden_at_hazelweb.co.uk> wrote in message news:t7memm66hebu55_at_xo.supernews.co.uk...
>
> "RS" <rs_at_rshome.u-net.com> wrote in message
> news:fiGe6.770$i54.979131_at_newsr1.u-net.net...
> >
> > CREATE OR REPLACE PROCEDURE submit_random_job
> > IS
> > lv_job BINARY_INTEGER;
> >
> > BEGIN
> >
> > dbms_output.ENABLE;
> >
> > DBMS_JOB.SUBMIT (lv_job,'GENERATE_RANDOM_STAT',
> > SYSDATE,
> > 'sysdate + 1/24');
> > COMMIT;
> >
> > dbms_output.put_line (lv_job);
> > END;
> >
> >
>
> Put a ; after your procedure name.
> DBMS_JOB.SUBMIT (lv_job,'GENERATE_RANDOM_STAT;',...........
>
> Jeremy
>
>
>
>
Received on Fri Feb 02 2001 - 17:07:43 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US