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

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