USER_JOBS¶
USER_JOBS displays all scheduled jobs owned by the current user. This view is accessible only to users with system administrator rights.
Name | Type | Description |
|---|---|---|
job | int4 | Job ID |
log_user | name not null | Username 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:
|
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 |