4.51 ALL_SCHEDULER_JOB_DESTS
ALL_SCHEDULER_JOB_DESTS displays information about the state of the jobs accessible to the current user at each of their destinations.
Related Views
-
DBA_SCHEDULER_JOB_DESTSdisplays information about the state of all jobs in the database at each of their destinations. -
USER_SCHEDULER_JOB_DESTSdisplays information about the state of the jobs owned by the current user at each of their destinations. This view does not display theOWNERcolumn.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Owner of the Scheduler job |
|
|
|
|
Name of the Scheduler job |
|
|
|
|
Subname of the Scheduler job |
|
|
|
|
Owner of the credential used for the remote destination |
|
|
|
|
Name of the credential used for the remote destination |
|
|
|
|
Owner of the destination object that points to the destination |
|
|
|
|
Name of the destination object or the name of the destination itself |
|
|
|
|
Numerical ID assigned to the job at this destination |
|
|
|
|
Indicates whether the parent job is enabled ( |
|
|
|
|
Indicates whether this destination and its agent are enabled ( |
|
|
|
|
State of this job at this destination:
|
|
|
|
|
Next start time of this job at this destination |
|
|
|
|
Number of times this job has run at this destination |
|
|
|
|
Number of times this job has been retried at this destination |
|
|
|
|
Number of times this job has failed at this destination |
|
|
|
|
Last time this job started at this destination |
|
|
|
|
Last time this job ended at this destination |
See Also: