oracle-databasejobsdbms-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

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