Updated on 2024-06-03 GMT+08:00

PG_JOB

PG_JOB records detailed information about jobs created by users. Dedicated threads poll the system catalog PG_JOB and trigger jobs based on scheduled job execution time, and update job status in PG_JOB. This system catalog belongs to the Shared Relation category. All job records are visible to all databases. Common users can access this system catalog only after being authorized.

Table 1 PG_JOB columns

Name

Type

Description

oid

oid

Row identifier (hidden attribute, which must be specified).

job_id

bigint

Job ID, which is the primary key and is unique (with a unique index).

current_postgres_pid

bigint

If the current job has been executed, the thread ID of this job is recorded. The default value is –1, indicating that the job has not yet been executed.

log_user

name

Username of the creator.

priv_user

name

Username of the job executor.

dbname

name

Name of the database in which the job will be executed.

node_name

name

Primary database node on which the job will be executed.

job_status

"char"

Execution status of the current task. The default value is 's'. The options are as follows:

  • 'r': running
  • 's': successfully finished
  • 'f': job failed
  • 'd': disable

If a job fails to be executed for 16 consecutive times, job_status is automatically set to 'd', and no more attempt will be made on this job.

Note: When you disable a scheduled job (by setting job_queue_processes to 0), the thread that monitors the job execution is not started, and the job status will not be updated. You can ignore this status. Only when the scheduled job function is enabled (job_queue_processes is not set to 0), the system updates the value of this column based on the real-time job status.

start_date

timestamp without time zone

Start time of the first job execution, accurate to millisecond.

next_run_date

timestamp without time zone

Time when a scheduled job is executed next time. The time is accurate to milliseconds.

failure_count

smallint

Number of times the job has started and failed. If a job fails to be executed for 16 consecutive times, no more attempt will be made on it.

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 schema used for job execution.

job_name

text

Name of the DBE_SCHEDULER scheduled job.

end_date

timestamp without time zone

Expiration time of the DBE_SCHEDULER scheduled job, accurate to millisecond.

enable

Boolean

Enabling status of the DBE_SCHEDULER scheduled job. The options are as follows:
  • true: enabled
  • false: disabled

failure_msg

text

Error information about the latest task execution.