Oracle Job not been executed for no reason

Question

Im programing a job in oracle in order to execute a store procedure, but when the time comes it just does not happend any thing for no reason.

Is there some kind of log where I can see if an error happend or something?

Im using the dbms_job package to create the job

Tnks.

Answer 1

Since you're using DBMS_JOB

• Are you committing after making the call to DBMS_JOB.SUBMIT? Your job can't run until you've committed.
• Have you set JOB_QUEUE_PROCESSES to a non-zero value? Are there any other DBMS_JOB jobs running in your system?
• Can you post the results of running 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>>