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

DBMS_JOB

From: A. Jensen <auj_at_storebrand.no>
Date: Fri, 23 Apr 1999 10:03:12 +0200
Message-ID: <vPVT2.39$qs2.417@news1.online.no>


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 - 03:03:12 CDT

Original text of this message

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