Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Problem with job

Problem with job

From: Daiminger, Helmut <Helmut.Daiminger_at_KirchGruppe.de>
Date: Wed, 19 Dec 2001 08:44:30 -0800
Message-ID: <F001.003E02C5.20011219075026@fatcity.com>

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 Received on Wed Dec 19 2001 - 10:44:30 CST

Original text of this message

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