3.53 ALL_SCHEDULER_JOBS
ALL_SCHEDULER_JOBS
displays information about the Scheduler jobs accessible to the current user.
Related Views
-
DBA_SCHEDULER_JOBS
displays information about all Scheduler jobs in the database. -
USER_SCHEDULER_JOBS
displays information about the Scheduler jobs owned by the current user. This view does not display theOWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the Scheduler job |
|
|
|
Name of the Scheduler job |
|
|
|
Subname of the Scheduler job (for a job running a chain step) |
|
|
|
Job style:
|
|
|
|
Original creator of the job |
|
|
|
Client identifier of the user creating the job |
|
|
|
Global user identifier of the user creating the job |
|
|
|
Owner of the program associated with the job |
|
|
|
Name of the program associated with the job |
|
|
|
Inline job action type:
|
|
|
|
Inline job action |
|
|
|
Inline number of job arguments |
|
|
|
Owner of the schedule that the job uses (can be a window or a window group) |
|
|
|
Name of the schedule that the job uses (can be a window or a window group) |
|
|
|
Type of the schedule that the job uses:
|
|
|
|
Original scheduled start date of the job (for an inline schedule) |
|
|
|
Inline schedule PL/SQL expression or calendar string |
|
|
|
Owner of the source queue into which the event will be raised |
|
|
|
Name of the source queue into which the event will be raised |
|
|
|
Name of the AQ agent used by the user on the event source queue (if it is a secure queue) |
|
|
|
Boolean expression used as the subscription rule for the event on the source queue |
|
|
|
Name of the rule used by the coordinator to trigger the event-based job |
|
|
|
Owner of the file watcher on which this job is based |
|
|
|
Name of the file watcher on which this job is based |
|
|
|
Date after which the job will no longer run (for an inline schedule) |
|
|
|
Name of the job class associated with the job |
|
|
|
Indicates whether the job is enabled ( |
|
|
|
Indicates whether the job will be dropped when it has completed ( |
|
|
|
Indicates whether the step should be restarted on database recovery ( |
|
|
|
Indicates whether the step should be restarted on application failure ( |
|
|
|
Current state of the job:
|
|
|
|
Priority of the job relative to other jobs in the same class |
|
|
|
Number of times the job has run |
|
|
|
Number of runs since the database last restarted. For in-memory jobs, this column is populated, but the For all other jobs, this column is This column is available starting with Oracle Database 12c Release 2 (12.2.0.1). |
|
|
|
Maximum number of times the job is scheduled to run |
|
|
|
Number of times the job has failed to run |
|
|
|
Number of failures since the database last restarted. For in-memory jobs, this column is populated, but the For all other jobs, this column is This column is available starting with Oracle Database 12c Release 2 (12.2.0.1). |
|
|
|
Number of times the job will be allowed to fail before being marked broken |
|
|
|
Number of times the job has retried, if it is retrying |
|
|
|
Last date on which the job started running |
|
|
|
Amount of time the job took to complete during the last run |
|
|
|
Next date on which the job is scheduled to run |
|
|
|
Time after which a job which has not run yet will be rescheduled |
|
|
|
Maximum amount of time for which the job will be allowed to run |
|
|
|
Amount of logging that will be done pertaining to the job:
|
|
|
|
Indicates whether all job output messages for the job are stored in the
|
|
|
|
Indicates whether the job will stop if a window associated with the job closes ( |
|
|
|
Indicates whether the job is sticky ( |
|
|
|
List of job events to raise for the job:
|
|
|
|
Indicates whether the job is a system job ( |
|
|
|
Weight of the job |
|
|
|
NLS environment of the job |
|
|
|
Source global database identifier |
|
|
|
Number of destinations associated with this job |
|
|
|
Owner of the destination object (if used), else NULL |
|
|
|
Destination that this job will run on |
|
|
|
Owner of the credential to be used for an external job |
|
|
|
Name of the credential to be used for an external job |
|
|
|
Instance on which the user requests the job to run |
|
|
|
Indicates whether the job will be dropped when completed due to user request ( |
|
|
|
Indicates whether the job is allowed to run in restricted session mode ( |
|
|
|
Comments on the job |
|
|
|
This column is for internal use |
|
|
|
Indicates whether the job can be restarted ( |
|
|
|
Indicates whether the job (not including the program of the job) is part of a resource constraint or incompatibility ( This column is available starting with Oracle Database 12c Release 2 (12.2.0.1). |
|
|
|
Owner of connect credential |
|
|
|
Name of connect credential |
|
|
|
Indicates whether this job fails on script error ( This column is available starting with Oracle Database 12c Release 2 (12.2.0.1). |
See Also: