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