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 |
Last Article: USER_IND_PARTITIONS
Next Article: USER_OBJECTS
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.