Updated on 2023-10-23 GMT+08:00

PG_JOB_PROC

PG_JOB_PROC records the content of each job in the PG_JOB table, including the PL/SQL code blocks and anonymous blocks. This part of job information is varchar(4000). Storing such information in the system catalog PG_JOB and loading it to the shared memory will result in excessive memory usage. Therefore, such information is stored in a separate table and is retrieved when needed.

Table 1 PG_JOB_PROC columns

Name

Type

Description

oid

oid

Row identifier (hidden attribute, which must be specified)

job_id

integer

Foreign key, which is associated with job_id in the system catalog PG_JOB

what

text

Job content, which is the program content in the DBE_SCHEDULER scheduled task.

job_name

text

Name of the DBE_SCHEDULER scheduled task or program.