Help Center> Data Warehouse Service> Developer Guide> System Catalogs and System Views> System Catalogs> PG_JOB_PROC
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. 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.
| Name | Type | Description |
|---|---|---|
| job_oid | integer | Foreign key, which is associated with job_id in the pg_job table |
| what | text | Job content |
Parent topic: System Catalogs
Last Article: PG_JOB
Next Article: PG_LANGUAGE
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.