PG_JOB_INFO
PG_JOB_INFO records the execution results of scheduled tasks. The schema of the system catalog is dbms_om.
| Column | Type | Description |
|---|---|---|
| job_id | Integer | Job ID |
| job_db | OID | OID of the database where the task is |
| start_time | Timestamp with zone | Task execution start time |
| status | character(8) | Task execution status |
| end_time | Timestamp with zone | Task execution end time |
| err_msg | Text | Task execution error information |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.