PG_JOB_PROC
PG_JOB_PROC records the content of each job in 13.2.71 PG_JOB, 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. Common users can access this system catalog only after being authorized.
|
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 13.2.71 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. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
