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