Lu, Huayi
e6fa411af0
Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com> Co-authored-by: Lu, Huayi <luhuayi@huawei.com> Co-committed-by: Lu, Huayi <luhuayi@huawei.com>
12 KiB
PG_JOBS
PG_JOBS records detailed information about jobs created by users. Dedicated threads poll the pg_jobs table and trigger jobs based on scheduled job execution time. This table belongs to the Shared Relation category. All job records are visible to all databases.
Name |
Type |
Description |
|---|---|---|
job_id |
integer |
Job ID, primary key, unique (with a unique index) |
what |
text |
Job content |
log_user |
oid |
Username of the job creator |
priv_user |
oid |
User ID of the job executor |
job_db |
oid |
OID of the database where the job is executed |
job_nsp |
oid |
OID of the namespace where a job is running |
job_node |
oid |
CN node on which the job will be created and executed |
is_broken |
boolean |
Indicates whether the current job is invalid. |
start_date |
timestamp without time zone |
Start time of the first job execution, accurate 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 |