Re: DBMS_JOB

Hello A. Jensen
you're not supposed to include the BEGIN and END segment in your statement calling DBMS_JOB. That's for dynamic SQL only (or an interactive SQL Plus session).

Hilsen en nordmann i Sverige !

--
Kjetil Nordstrand
RKS Data AB, Karlstad, Sweden

A. Jensen skrev i meddelandet ...


>I have submitted and commited the following job (logged on as myself,

 having


>DBA-role):

> sys.dbms_job.submit(jobno, 'BEGIN SYS.DBMS_UTILITY.ANALYZE_SCHEMA(''L6'',

>''COMPUTE''); END;', SYSDATE, 'TRUNC(SYSDATE+1)');

>

>The job is in the queue, but failes. Why?

>I have tried to run it immediately, calling dbms_job.run. Result:

>ORA-12011: Execution of 1 jobs failed.

>ORA-06512: at "SYS.DBMS_IJOB", line 255

>ORA-06512: at "SYS.DBMS_JOB", line 219

>ORA-06512: at line 2

>

>When I run the script directly, it works OK

>BEGIN

>    SYS.DBMS_UTILITY.ANALYZE_SCHEMA(''L6'', ''COMPUTE'');

>END;

>

>What am I missing??

>

>Audun

>

>