error running a job [message #8834] |
Mon, 29 September 2003 10:53 |
Dave
Messages: 92 Registered: August 1999
|
Member |
|
|
Using Oracle 9 I created a job as follows.
DECLARE jobno number;
BEGIN
DBMS_JOB.SUBMIT(jobno,
'ACEMAN.PDA_INSERT.ACEMAN_PDA_DATA_INSERT;',
sysdate,'sysdate + 1/48');
COMMIT;
END;
When I run it I get the following error:
ORA-12011:execution of job failed
ORA-06512: at "SYS.DBMS_IJOB",line 406
ORA-06512: at "SYS.DBMS_JOB",line 272
ORA-06512: at line 2
But when I check the tables I see that the procedure that is called ran fine.
Any help would be appreciated.
|
|
|
|