Help Center > > Developer Guide> System Catalogs and System Views> System Views> USER_JOBS

USER_JOBS

Updated at: Mar 13, 2020 GMT+08:00

USER_JOBS displays all jobs owned by the user.

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 last 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

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= 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

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

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel