Problem with job

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