Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: DBMS_JOB question
...and the error message is ...?
-- Vladimir Zakharychev (bob@dpsp-yes.com) http://www.dpsp-yes.com Dynamic PSP(tm) - the first true RAD toolkit for Oracle-based internet applications. All opinions are mine and do not necessarily go in line with those of my employer. "Jan Gelbrich" <j_gelbrich_at_westfalen-blatt.de> wrote in message news:arvrqn$m9q0u$1_at_ID-152732.news.dfncis.de...Received on Tue Nov 26 2002 - 07:16:22 CST
> Hello, folks,
>
> I maybe a complete blind fish, but why the heck wont the folowing compile ?
>
> DECLARE
> jobno number;
> BEGIN
> DBMS_JOB.SUBMIT(jobno,
> 'sys.jg_load_objects', --an SP that has already been tested
> successfully
> SYSDATE,
> 'SYSDATE + 1/48' --every half an hour
> );
> END;
> /
>
> AFAIK it complies with the examples in the online doc CD. I compared Tom
> Kytes book as well ... I have no clue.
>
> Any comments are appreciated. ThanX !
> Oracle EE 8.1.7, SQL*Plus
>
> Jan
>
>