PG_JOB
PG_JOB displays detailed information about scheduled tasks created by users.
The PG_JOB view replaces the PG_JOB system catalog in earlier versions and provides forward compatibility with earlier versions. The original PG_JOB system catalog is changed to the PG_JOBS system catalog. For details about PG_JOBS, see PG_JOBS.
Name |
Type |
Description |
---|---|---|
job_id |
bigint |
Job ID |
current_postgres_pid |
bigint |
If the current job has been executed, the PostgreSQL thread ID of this job is recorded. The default value is -1, indicating that the task is not executed or has been executed. |
log_user |
name |
User name of the job creator |
priv_user |
name |
User name of the job executor |
dbname |
name |
Name of the database where the job is executed |
node_name |
name |
CN node on which the job will be created and executed |
job_status |
text |
Status of the current job. The value range is r, s, f, or d. The default value is s. The indications are as follows:
NOTE:
|
start_date |
timestamp without time zone |
Start time of the first job execution, precise to millisecond |
next_run_date |
timestamp without time zone |
Scheduled time of the next job execution, accurate to millisecond |
failure_count |
smallint |
Number of consecutive failures. |
interval |
text |
Job execution interval |
last_start_date |
timestamp without time zone |
Start time of the last job execution, accurate to millisecond |
last_end_date |
timestamp without time zone |
End time of the last job execution, accurate to millisecond |
last_suc_date |
timestamp without time zone |
Start time of the last successful job execution, accurate to millisecond |
this_run_date |
timestamp without time zone |
Start time of the ongoing job execution, accurate to millisecond |
nspname |
name |
Name of the namespace where a job is running |
what |
text |
Job content |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot