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_JOB question

Re: DBMS_JOB question

From: Vladimir M. Zakharychev <bob_at_dpsp-yes.com>
Date: Tue, 26 Nov 2002 16:16:22 +0300
Message-ID: <arvsbb$7sr$1@babylon.agtel.net>


...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...

> 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:16:22 CST

Original text of this message

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