DBMS_JOB question

From: Jan Gelbrich <j_gelbrich_at_westfalen-blatt.de>
Date: Tue, 26 Nov 2002 14:09:00 +0100
Message-ID: <arvrqn$m9q0u$1@ID-152732.news.dfncis.de>

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 Received on Tue Nov 26 2002 - 07:09:00 CST