Search code examples
oraclejobsdbms-job

Oracle Job not been executed for no reason

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.

Solution

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