Oracle Job failed for no reason

Question

Im programming a job in oracle to execute a repository procedure, but when the time comes, nothing just happens for no reason.

Is there some kind of journal where I can see if an error has occurred or something else?

I am using the dbms_job package to create a job

Tnks.

Answer 1

Since you are using DBMS_JOB

• Do you execute after calling DBMS_JOB.SUBMIT? Your work cannot work until you have completed it.
• Have you set JOB_QUEUE_PROCESSES to a non-zero value? Are there any other DBMS_JOB jobs on your system?
• Can you post the results of the following query:

SELECT last_date, 
       last_sec, 
       next_date, 
       next_sec, 
       this_date, 
       this_sec, 
       broken, 
       failures, 
       total_time
  FROM dba_jobs
 WHERE job = <<your job number>>