[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | CDB_SCHEDULER_JOBS |
|---|---|
| Object Type: | VIEW |
| Owner: | SYS |
| Subobject Name: | |
| Status: | VALID |
All scheduler jobs in the database in all containers
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| OWNER | VARCHAR2 | (30) | Owner of the scheduler job | |
| JOB_NAME | VARCHAR2 | (128) | Name of the scheduler job | |
| JOB_SUBNAME | VARCHAR2 | (128) | Subname of the scheduler job (for a job running a chain step) | |
| JOB_STYLE | VARCHAR2 | (17) | Job style - regular, lightweight or volatile | |
| JOB_CREATOR | VARCHAR2 | (128) | Original creator of this job | |
| CLIENT_ID | VARCHAR2 | (65) | Client id of user creating job | |
| GLOBAL_UID | VARCHAR2 | (33) | Global uid of user creating this job | |
| PROGRAM_OWNER | VARCHAR2 | (4000) | Owner of the program associated with the job | |
| PROGRAM_NAME | VARCHAR2 | (4000) | Name of the program associated with the job | |
| JOB_TYPE | VARCHAR2 | (16) | Inlined job action type | |
| JOB_ACTION | VARCHAR2 | (4000) | Inlined job action | |
| NUMBER_OF_ARGUMENTS | NUMBER | Inlined job number of arguments | ||
| SCHEDULE_OWNER | VARCHAR2 | (4000) | Owner of the schedule that this job uses (can be a window or window group) | |
| SCHEDULE_NAME | VARCHAR2 | (4000) | Name of the schedule that this job uses (can be a window or window group) | |
| SCHEDULE_TYPE | VARCHAR2 | (12) | Type of the schedule that this job uses | |
| START_DATE | TIMESTAMP(6) WITH TIME ZONE | (13) | Original scheduled start date of this job (for an inlined schedule) | |
| REPEAT_INTERVAL | VARCHAR2 | (4000) | Inlined schedule PL/SQL expression or calendar string | |
| EVENT_QUEUE_OWNER | VARCHAR2 | (128) | Owner of source queue into which event will be raised | |
| EVENT_QUEUE_NAME | VARCHAR2 | (128) | Name of source queue into which event will be raised | |
| EVENT_QUEUE_AGENT | VARCHAR2 | (256) | Name of AQ agent used by user on the event source queue (if it is a secure queue) | |
| EVENT_CONDITION | VARCHAR2 | (4000) | Boolean expression used as subscription rule for event on the source queue | |
| EVENT_RULE | VARCHAR2 | (261) | Name of rule used by the coordinator to trigger event based job | |
| FILE_WATCHER_OWNER | VARCHAR2 | (261) | Owner of file watcher on which this job is based | |
| FILE_WATCHER_NAME | VARCHAR2 | (261) | Name of file watcher on which this job is based | |
| END_DATE | TIMESTAMP(6) WITH TIME ZONE | (13) | Date after which this job will no longer run (for an inlined schedule) | |
| JOB_CLASS | VARCHAR2 | (30) | Name of job class associated with the job | |
| ENABLED | VARCHAR2 | (5) | Whether the job is enabled | |
| AUTO_DROP | VARCHAR2 | (5) | Whether this job will be dropped when it has completed | |
| RESTART_ON_RECOVERY | VARCHAR2 | (5) | Whether this job can be restarted after a db crash | |
| RESTART_ON_FAILURE | VARCHAR2 | (5) | Whether this job can be re-tried if it fails | |
| STATE | VARCHAR2 | (15) | Current state of the job | |
| JOB_PRIORITY | NUMBER | Priority of the job relative to others within the same class | ||
| RUN_COUNT | NUMBER | Number of times this job has run | ||
| MAX_RUNS | NUMBER | Maximum number of times this job is scheduled to run | ||
| FAILURE_COUNT | NUMBER | Number of times this job has failed to run | ||
| MAX_FAILURES | NUMBER | Number of times this job will be allowed to fail before being marked broken | ||
| RETRY_COUNT | NUMBER | Number of times this job has retried, if it is retrying. | ||
| LAST_START_DATE | TIMESTAMP(6) WITH TIME ZONE | (20) | Last date on which the job started running | |
| LAST_RUN_DURATION | INTERVAL DAY(9) TO SECOND(6) | (11) | How long the job took last time | |
| NEXT_RUN_DATE | TIMESTAMP(6) WITH TIME ZONE | (20) | Next date the job is scheduled to run on | |
| SCHEDULE_LIMIT | INTERVAL DAY(3) TO SECOND(0) | (11) | Time in minutes after which a job which has not run yet will be rescheduled | |
| MAX_RUN_DURATION | INTERVAL DAY(3) TO SECOND(0) | (11) | This column is reserved for future use | |
| LOGGING_LEVEL | VARCHAR2 | (11) | Amount of logging that will be done pertaining to this job | |
| STORE_OUTPUT | VARCHAR2 | (5) | Determines if full job output is to be stored | |
| STOP_ON_WINDOW_CLOSE | VARCHAR2 | (5) | Whether this job will stop if a window it is associated with closes | |
| INSTANCE_STICKINESS | VARCHAR2 | (5) | Whether this job is sticky | |
| RAISE_EVENTS | VARCHAR2 | (4000) | List of job events to raise for this job | |
| SYSTEM | VARCHAR2 | (5) | Whether this is a system job | |
| JOB_WEIGHT | NUMBER | Weight of this job | ||
| NLS_ENV | VARCHAR2 | (4000) | NLS environment of this job | |
| SOURCE | VARCHAR2 | (128) | Source global database identifier | |
| NUMBER_OF_DESTINATIONS | NUMBER | |||
| DESTINATION_OWNER | VARCHAR2 | (128) | Owner of destination object (if used) else NULL | |
| DESTINATION | VARCHAR2 | (128) | Destination that this job will run on | |
| CREDENTIAL_OWNER | VARCHAR2 | (128) | Owner of login credential | |
| CREDENTIAL_NAME | VARCHAR2 | (128) | Name of login credential | |
| INSTANCE_ID | NUMBER | Instance user requests job to run on. | ||
| DEFERRED_DROP | VARCHAR2 | (5) | Whether this job will be dropped when completed due to user request. | |
| ALLOW_RUNS_IN_RESTRICTED_MODE | VARCHAR2 | (5) | ||
| COMMENTS | VARCHAR2 | (240) | Comments on the job | |
| FLAGS | NUMBER | This column is for internal use. | ||
| RESTARTABLE | VARCHAR2 | (5) | Whether this job can be restarted or not | |
| CONNECT_CREDENTIAL_OWNER | VARCHAR2 | (128) | Owner of connect credential | |
| CONNECT_CREDENTIAL_NAME | VARCHAR2 | (128) | Name of connect credential | |
| CON_ID | NUMBER | container id |
Cut, paste (and edit) the following text to query this object:
SELECT OWNER
, JOB_NAME
, JOB_SUBNAME
, JOB_STYLE
, JOB_CREATOR
, CLIENT_ID
, GLOBAL_UID
, PROGRAM_OWNER
, PROGRAM_NAME
, JOB_TYPE
, JOB_ACTION
, NUMBER_OF_ARGUMENTS
, SCHEDULE_OWNER
, SCHEDULE_NAME
, SCHEDULE_TYPE
, START_DATE
, REPEAT_INTERVAL
, EVENT_QUEUE_OWNER
, EVENT_QUEUE_NAME
, EVENT_QUEUE_AGENT
, EVENT_CONDITION
, EVENT_RULE
, FILE_WATCHER_OWNER
, FILE_WATCHER_NAME
, END_DATE
, JOB_CLASS
, ENABLED
, AUTO_DROP
, RESTART_ON_RECOVERY
, RESTART_ON_FAILURE
, STATE
, JOB_PRIORITY
, RUN_COUNT
, MAX_RUNS
, FAILURE_COUNT
, MAX_FAILURES
, RETRY_COUNT
, LAST_START_DATE
, LAST_RUN_DURATION
, NEXT_RUN_DATE
, SCHEDULE_LIMIT
, MAX_RUN_DURATION
, LOGGING_LEVEL
, STORE_OUTPUT
, STOP_ON_WINDOW_CLOSE
, INSTANCE_STICKINESS
, RAISE_EVENTS
, SYSTEM
, JOB_WEIGHT
, NLS_ENV
, SOURCE
, NUMBER_OF_DESTINATIONS
, DESTINATION_OWNER
, DESTINATION
, CREDENTIAL_OWNER
, CREDENTIAL_NAME
, INSTANCE_ID
, DEFERRED_DROP
, ALLOW_RUNS_IN_RESTRICTED_MODE
, COMMENTS
, FLAGS
, RESTARTABLE
, CONNECT_CREDENTIAL_OWNER
, CONNECT_CREDENTIAL_NAME
, CON_ID
FROM SYS.CDB_SCHEDULER_JOBS;
SYS.CDB_SCHEDULER_JOBS does not reference any database object
SYS.CDB_SCHEDULER_JOBS is referenced by following:
PUBLIC
CDB_SCHEDULER_JOBS
|
|
|
|