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