Lu, Huayi
a24ca60074
Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com> Co-authored-by: Lu, Huayi <luhuayi@huawei.com> Co-committed-by: Lu, Huayi <luhuayi@huawei.com>
14 KiB
USER_JOBS
USER_JOBS displays all jobs owned by the user.
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:
|
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 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 |