Problem with ORACLE JOB

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

Was this dbms_job ran in Spain?

Yap in Spain :D

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

Tamil

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

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.

Quote:

---

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???