> "Daiminger, Helmut" wrote: > > Hi! > > I created a new job in a database: > > variable jobno number; > begin > dbms_job.submit (:jobno, 'statspack.snap;', sysdate, 'trunc > (sysdate,''HH24'') + trunc ((sysdate - trunc (sysdate, > ''HH24''))*96+1)/96'); > > commit; > end; > > The job was successfully created. But when I try to run the job, I get > the following error message: > > BEGIN dbms_job.run(127); > > * > ERROR at line 1: > ORA-12011: execution of 1 jobs failed > ORA-06512: at "SYS.DBMS_IJOB", line 405 > ORA-06512: at "SYS.DBMS_JOB", line 267 > ORA-06512: at line 1 > > Any idea what's wrong here? > > This is 8.1.7 on Sun Solaris. > > Thanks, > Helmut
Problem with job is that you know that they have failed, but you don't know why. I suggest you encapsulate your procedures in a procedure which logs what goes wrong. There are some details on how to do this in the 'Aunt Augusta' section of the Oriole site. -- HTH, Stephane Faroult Oriole Ltd -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).