Updated on 2024-09-30 GMT+08:00

PG_JOB_INFO

PG_JOB_INFO records the execution results of scheduled tasks. The schema of the system catalog is dbms_om.

Table 1 dbms_om.pg_job_info columns

Name

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