• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. Systems Tables and Views
  5. PG_JOB_PROC

PG_JOB_PROC

PG_JOB_PROC records the content of each job in the pg_job table, that is, the PL/SQL code blocks and anonymous blocks to be executed by each job. In the Oracle database, this part of the job information is varchar(4000). Storing such information in the pg_job table 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

job_oid

integer

Foreign key, which is associated with job_id in the pg_job table

what

text

PL/SQL blocks or anonymous block that the job executes