USER_JOBS
USER_JOBS displays all scheduled jobs owned by the current user. This view is accessible only to users with system administrator rights.
| Column | 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 consecutive failures. |
| what | Text | Body of the PL/SQL blocks or anonymous clock that the job executes |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
