USER_JOBS

USER_JOBS displays all jobs owned by the user. It is accessible only to users with system administrator rights.

Table 1 USER_JOBS columns

Name

Type

Description

job

int4

Job ID

log_user

name not null

User name of the job creator

priv_user

name not null

User name of the job executor

dbname

name not null

Database in which the job is created

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

this_date

timestamp without time zone

Start time of the ongoing job execution

this suc

text

Same as THIS_DATE

next_date

timestamp without time zone

Schedule time of the next job execution

next suc

text

Same as next_date

broken

text

Task status

Y: the system does not try to execute the task.

N: the system attempts to execute the task.

status

char

Status of the current job. The value range is 'r', 's', 'f', 'd'. The default value is 's'. The indications are as follows:

  • r: running

  • s: finished

  • f: failed

  • d: aborted

interval

text

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

failures

smallint

Number of consecutive failures.

what

text

Body of the PL/SQL blocks or anonymous clock that the job executes