Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-8.x)/ System Catalogs and System Views/ System Views/ Other System Views/ MY_JOBS
Updated on 2025-08-19 GMT+08:00
View PDF

MY_JOBS

MY_JOBS displays details about the scheduled tasks owned by the current 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 the job creator.

priv_user

name

Username of the job executor.

dbname

name

Name of the database where the job is created.

schema_user

name

Default schema name of a scheduler job.

start_date

timestamp without time zone

Job start time.

start_suc

text

Start time of the 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.

last_sec

text

Start time of the last successful job execution. Compatibility is supported.

this_date

timestamp without time zone

Start time of the ongoing job execution.

this_suc

text

Start time of the ongoing successful job execution.

this_sec

text

Start time of an ongoing successful job execution. Compatibility is supported.

next_date

timestamp without time zone

Schedule time of the next job execution.

next_suc

text

Schedule time of the next successful job execution.

next_sec

text

Schedule time of the next successful job execution. Compatibility is supported.

total_time

numeric

Latest execution duration of a task.

broken

text

y if the job status 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'.
  • r: running
  • s: successful execution
  • f: failed execution
  • d: canceling an execution

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.

nls_env

character varying(4000)

Not supported. Set it to NULL.

misc_env

raw

Not supported. Set it to NULL.

instance

numeric

Not supported. Set it to NULL.
Parent topic: Other System Views