How to accurately trace the execution logs of scheduled jobs

mugi-san
Kilo Sage

yesterday

Hello, Everyone.

 

I found the sys_scheduler_job_history table, but unfortunately, it doesn't seem to record the start time, end time, or success/failure status.

I believe that outputting messages to the system log and then searching through them to find what I need is not a very "smart" or efficient implementation.

Does anyone know if there is a standard table or feature that records the start time, end time, and execution status of scheduled jobs?

0 Helpfuls
  • 124 Views
2 REPLIES 2

Sanjay191
Kilo Patron

yesterday

Hi @mugi-san 

The standard way to track scheduled job execution is through System Diagnostics:

  • System Diagnostics → Scheduled Jobs Dashboard
    Provides execution details such as start time, end time, duration, and status.

  • System Diagnostics → Transactions
    Each scheduled job run generates a transaction showing precise timing and execution information.

    Sanjay191_0-1770019041998.png

     


    If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.
    Thank You

0 Helpfuls

mugi-san
Kilo Sage
In response to Sanjay191

45m ago

Thanks, @Sanjay191 .

While the dashboard you shared displays information from the sys_scheduler_job_history table, please note that it does not record precise start/end times or the success/failure status. It is primarily for monitoring processing duration rather than indicating whether the job schedule itself executed successfully.

Regarding the transaction table, I believe tracking will be difficult because the transaction logs do not capture information searchable by job name, and similarly, the transaction end times are not recorded.

Regards.

0 Helpfuls