list_scheduler_job_runs
Retrieve recent Oracle DBMS_SCHEDULER job run details—start time, duration, instance/session IDs, and errors—to diagnose job history. Filter by schema or job name and set a row limit.
Instructions
List recent DBMS_SCHEDULER job run details: start time, run duration, instance id, session id, error code, additional info. Ordered by start time desc. (operation/status live in ALL_SCHEDULER_JOB_LOG, not the run-details view.)
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Maximum number of rows to return (default 20). | |
| schema | No | Schema (owner) name. Omit to search all schemas. | |
| jobName | No | Optional job name filter. |