Problem with ORACLE JOB

[novacd]

We are trying to execute a JOB by "DBMS_JOB.RUN(Procedure_ID)" command... and we obtained this error:

ERROR en lÃ*nea 1:
ORA-12011: la ejecución de 1 trabajos ha fallado
ORA-06512: en "SYS.DBMS_IJOB", lÃ*nea 405
ORA-06512: en "SYS.DBMS_JOB", lÃ*nea 267
ORA-06512: en lÃ*nea 1

Thx in advance.

Regards

[tamilselvan]

Was this dbms_job ran in Spain?

[novacd]

Yap in Spain

[tamilselvan]

Does your procedure handle exception?
Did you check up alert log?

Tamil

[novacd]

We don't have many Administration concepts... can any1 pls tell me how the **** we can check the "famous" Alert Log?

[Coco]

Hellow novacd,
how have you created your job?
I think your problem is like this:
you have created your job

VARIABLE Job_number NUMBER;
BEGIN
DBMS_JOB.SUBMIT(:Job_number,'Procedure_name', ...)
END;

try do it so:

VARIABLE Job_number NUMBER;
EXEC DBMS_JOB.SUBMIT(:Job_number,'Procedure_name', ...);

Is incredible, but it's true.
I had the same problem, and I resolve it so.

[jmodic]

Originally posted by Coco
Hellow novacd,
how have you created your job?
I think your problem is like this:
you have created your job

VARIABLE Job_number NUMBER;
BEGIN
DBMS_JOB.SUBMIT(:Job_number,'Procedure_name', ...)
END;

try do it so:

VARIABLE Job_number NUMBER;
EXEC DBMS_JOB.SUBMIT(:Job_number,'Procedure_name', ...);

Is incredible, but it's true.
I had the same problem, and I resolve it so.

Has anybody said he is using SQL*Plus to start the job???