Re: DBMS_JOB

You don't need the BEGIN/END in the job to execute, just the package to call with parameters....

SQL> exec sys.dbms_job.submit(jobno,
'SYS.DBMS_UTILITY.ANALYZE_SCHEMA(''L6'',''COMPUTE'')', SYSDATE, 'TRUNC(SYSDATE+1)'); Graham

1. Jensen <auj_at_storebrand.no> wrote in article <vPVT2.39$qs2.417_at_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
   >
   >
   >