1

At my workplace, I've got some procedures, that are supposed to run automatically, at a specific time, but sometimes they fail.

I come to know about the failure of procedures about 1-2 hrs after the failure, that too if i manually check it.

What i'm trying to do now that if a procedure fails, i should receive a mail on my email id.But, for that i need a way to track the status of procedure run. Is there any way in oracle where i can track whether the procedure run was successful or not , within 15 minutes of the procedure run. Does oracle creates any kind of logs that says so?

Justin Cave
  • 227,342
  • 24
  • 367
  • 384
user3146332
  • 51
  • 3
  • 12
  • Why is this tagged for both Oracle and MySQL? How are the procedures being run? Via a `dbms_job` or `dbms_scheduler` job? Via some external scheduler? – Justin Cave Sep 06 '14 at 04:44

1 Answers1

2

Since you're using dbms_scheduler to run the job, you would just need to consult the [dba|all|user]_scheduler_job_run_details table to see information about the job log information. That includes things like when the job was scheduled to be run, when it actually ran, how long it ran, whether there was an error, etc.

Justin Cave
  • 227,342
  • 24
  • 367
  • 384