Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DBMS_JOBS problem
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