DBA_SCHEDULER_JOB_ROLES
displays information about all Scheduler jobs in the database by database role.
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) |
|
|
|
Creator of the Scheduler job |
|
|
|
Name of the database role |
|
|
|
Owner of the program associated with the job |
|
|
|
Name of the program associated with the job |
|
|
|
Inline job action type:
|
|
|
|
Inline job action |
|
|
|
Name of the job class associated with the job |
|
|
|
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 |
|
|
|
Date after which the job will no longer run (for an inline schedule) |
|
|
|
Last date on which the job ran |
|
|
|
Indicates whether the job is enabled ( |
|
|
|
Current state of the job:
|
|
|
|
Comments on the job |