HomeMogDBMogDB StackUqbar
v2.1

Documentation:v2.1

Supported Versions:

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. 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_oid integer Foreign key, which is associated with job_id in the system catalog PG_JOB
what text Job content
job_name text Job name
Copyright © 2011-2024 www.enmotech.com All rights reserved.