DBMS_JOB

From: A. Jensen <auj_at_storebrand.no>
Date: 1999/04/23
Message-ID: <vPVT2.39$qs2.417@news1.online.no>#1/1

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 Received on Fri Apr 23 1999 - 00:00:00 CDT