Updated on 2023-10-23 GMT+08:00

MY_JOBS

MY_JOBS displays all jobs owned by the user. This view exists in the PG_CATALOG and SYS schemas.

Table 1 MY_JOBS columns

Name

Type

Description

job

bigint

Job ID

log_user

name

Username of a job creator

priv_user

name

Username of a job executor

dbname

name

Name of the database in which a job is created

start_date

timestamp without time zone

Job start time

start_suc

text

Start time of a successful job execution

last_date

timestamp without time zone

Start time of the last job execution

last_suc

text

Start time of the last successful job execution

this_date

timestamp without time zone

Start time of an ongoing job execution

this_suc

text

Start time of an ongoing successful job execution

next_date

timestamp without time zone

Schedule time of the next job execution

next_suc

text

Schedule time of the next successful job execution

broken

text

The value is y if the job state is broken and n if otherwise.

status

"char"

Status of the current job. The value can be r, s, f, or d. The default value is r.

Status of job step:
  • r=running
  • s=successfully finished
  • f= job failed
  • d=aborted

interval

text

Time expression used to calculate the next time the job will be executed. If this parameter is set to null, the job will be executed once only.

failures

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.

what

text

Executable job