• Data Warehouse Service

dws
  1. Help Center
  2. Data Warehouse Service
  3. Developer Guide
  4. Systems Tables and Views
  5. USER_JOBS

USER_JOBS

USER_JOBS describes all jobs owned by the user.

Table 1 PG_JOB 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 last successful job execution

last_date

timestamp without time zone

Start time of the last job execution

last_sec

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

y if the job status is broken and n if otherwise

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:

Status of job step:

  • r=running
  • s=successfully finished
  • f=failed stopping job
  • 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

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