ALL_SCHEDULER_JOBS 分手后的思念是犯贱 2023-10-08 08:31 43阅读 0赞 ## 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 the `OWNER` column. <table> <thead> <tr> <th>Column</th> <th>Datatype</th> <th>NULL</th> <th>Description</th> </tr> </thead> <tbody> <tr> <td><code>OWNER</code></td> <td><code>VARCHAR2(30)</code></td> <td><code>NOT NULL</code></td> <td>Owner of the Scheduler job</td> </tr> <tr> <td><code>JOB_NAME</code></td> <td><code>VARCHAR2(30)</code></td> <td><code>NOT NULL</code></td> <td>Name of the Scheduler job</td> </tr> <tr> <td><code>JOB_SUBNAME</code></td> <td><code>VARCHAR2(30)</code></td> <td> </td> <td>Subname of the scheduler job (for a job running a chain step)</td> </tr> <tr> <td><code>JOB_CREATOR</code></td> <td><code>VARCHAR2(30)</code></td> <td> </td> <td>Original creator of the job</td> </tr> <tr> <td><code>CLIENT_ID</code></td> <td><code>VARCHAR2(64)</code></td> <td> </td> <td>Client identifier of the user creating the job</td> </tr> <tr> <td><code>GLOBAL_UID</code></td> <td><code>VARCHAR2(32)</code></td> <td> </td> <td>Global user identifier of the user creating the job</td> </tr> <tr> <td><code>PROGRAM_OWNER</code></td> <td><code>VARCHAR2(4000)</code></td> <td> </td> <td>Owner of the program associated with the job</td> </tr> <tr> <td><code>PROGRAM_NAME</code></td> <td><code>VARCHAR2(4000)</code></td> <td> </td> <td>Name of the program associated with the job</td> </tr> <tr> <td><code>JOB_TYPE</code></td> <td><code>VARCHAR2(16)</code></td> <td> </td> <td>Inline job action type: <ul> <li> <p><code>PLSQL_BLOCK</code></p> </li> <li> <p><code>STORED_PROCEDURE</code></p> </li> <li> <p><code>EXECUTABLE</code></p> </li> <li> <p><code>CHAIN</code></p> </li> </ul></td> </tr> <tr> <td><code>JOB_ACTION</code></td> <td><code>VARCHAR2(4000)</code></td> <td> </td> <td>Inline job action</td> </tr> <tr> <td><code>NUMBER_OF_ARGUMENTS</code></td> <td><code>NUMBER</code></td> <td> </td> <td>Inline number of job arguments</td> </tr> <tr> <td><code>SCHEDULE_OWNER</code></td> <td><code>VARCHAR2(4000)</code></td> <td> </td> <td>Owner of the job's schedule (can be a window or a window group)</td> </tr> <tr> <td><code>SCHEDULE_NAME</code></td> <td><code>VARCHAR2(4000)</code></td> <td> </td> <td>Name of the job's schedule (can be a window or a window group)</td> </tr> <tr> <td><code>SCHEDULE_TYPE</code></td> <td><code>VARCHAR2(12)</code></td> <td> </td> <td>The type of schedule. Possible values are as follows: <ul> <li> <p><code>IMMEDIATE</code> - start date and repeat interval are null</p> </li> <li> <p><code>ONCE</code> - repeat interval is null</p> </li> <li> <p><code>PLSQL</code> - PL/SQL expression used as schedule</p> </li> <li> <p><code>CALENDAR</code> - Oracle calendaring expression used as schedule</p> </li> <li> <p><code>EVENT</code> - event schedule</p> </li> <li> <p><code>NAMED</code> - a named schedule</p> </li> <li> <p><code>WINDOW</code> - window used as schedule</p> </li> <li> <p><code>WINDOW_GROUP</code> - window group used as schedule</p> </li> </ul></td> </tr> <tr> <td><code>START_DATE</code></td> <td><code>TIMESTAMP(6) WITH TIME ZONE</code></td> <td> </td> <td>Original scheduled start date of the job (for an inline schedule)</td> </tr> <tr> <td><code>REPEAT_INTERVAL</code></td> <td><code>VARCHAR2(4000)</code></td> <td> </td> <td>Inline schedule PL/SQL expression or calendar string</td> </tr> <tr> <td><code>EVENT_QUEUE_OWNER</code></td> <td><code>VARCHAR2(30)</code></td> <td> </td> <td>Owner of the source queue into which the event will be raised</td> </tr> <tr> <td><code>EVENT_QUEUE_NAME</code></td> <td><code>VARCHAR2(30)</code></td> <td> </td> <td>Name of the source queue into which the event will be raised</td> </tr> <tr> <td><code>EVENT_QUEUE_AGENT</code></td> <td><code>VARCHAR2(30)</code></td> <td> </td> <td>Name of the AQ agent used by the user on the event source queue (if it is a secure queue)</td> </tr> <tr> <td><code>EVENT_CONDITION</code></td> <td><code>VARCHAR2(4000)</code></td> <td> </td> <td>Boolean expression used as the subscription rule for the event on the source queue</td> </tr> <tr> <td><code>EVENT_RULE</code></td> <td><code>VARCHAR2(65)</code></td> <td> </td> <td>Name of the rule used by the coordinator to trigger the event-based job</td> </tr> <tr> <td><code>END_DATE</code></td> <td><code>TIMESTAMP(6) WITH TIME ZONE</code></td> <td> </td> <td>Date after which the job will no longer run (for an inline schedule)</td> </tr> <tr> <td><code>JOB_CLASS</code></td> <td><code>VARCHAR2(30)</code></td> <td> </td> <td>Name of the job class associated with the job</td> </tr> <tr> <td><code>ENABLED</code></td> <td><code>VARCHAR2(5)</code></td> <td> </td> <td>Indicates whether the job is enabled (<code>TRUE</code>) or not (<code>FALSE</code>)</td> </tr> <tr> <td><code>AUTO_DROP</code></td> <td><code>VARCHAR2(5)</code></td> <td> </td> <td>Indicates whether the job will be dropped when it has completed (<code>TRUE</code>) or not (<code>FALSE</code>)</td> </tr> <tr> <td><code>RESTARTABLE</code></td> <td><code>VARCHAR2(5)</code></td> <td> </td> <td>Indicates whether the job can be restarted (<code>TRUE</code>) or not (<code>FALSE</code>)</td> </tr> <tr> <td><code>STATE</code></td> <td><code>VARCHAR2(15)</code></td> <td> </td> <td>Current state of the job: <ul> <li> <p><code>DISABLED</code></p> </li> <li> <p><code>RETRY SCHEDULED</code></p> </li> <li> <p><code>SCHEDULED</code></p> </li> <li> <p><code>RUNNING</code></p> </li> <li> <p><code>COMPLETED</code></p> </li> <li> <p><code>BROKEN</code></p> </li> <li> <p><code>FAILED</code></p> </li> <li> <p><code>REMOTE</code></p> </li> <li> <p><code>SUCCEEDED</code></p> </li> <li> <p><code>CHAIN_STALLED</code></p> </li> </ul></td> </tr> <tr> <td><code>JOB_PRIORITY</code></td> <td><code>NUMBER</code></td> <td> </td> <td>Priority of the job relative to other jobs in the same class</td> </tr> <tr> <td><code>RUN_COUNT</code></td> <td><code>NUMBER</code></td> <td> </td> <td>Number of times the job has run</td> </tr> <tr> <td><code>MAX_RUNS</code></td> <td><code>NUMBER</code></td> <td> </td> <td>Maximum number of times the job is scheduled to run</td> </tr> <tr> <td><code>FAILURE_COUNT</code></td> <td><code>NUMBER</code></td> <td> </td> <td>Number of times the job has failed to run</td> </tr> <tr> <td><code>MAX_FAILURES</code></td> <td><code>NUMBER</code></td> <td> </td> <td>Number of times the job will be allowed to fail before being marked broken</td> </tr> <tr> <td><code>RETRY_COUNT</code></td> <td><code>NUMBER</code></td> <td> </td> <td>Number of times the job has retried, if it is retrying</td> </tr> <tr> <td><code>LAST_START_DATE</code></td> <td><code>TIMESTAMP(6) WITH TIME ZONE</code></td> <td> </td> <td>Last date on which the job started running</td> </tr> <tr> <td><code>LAST_RUN_DURATION</code></td> <td><code>INTERVAL DAY(9) TO SECOND(6)</code></td> <td> </td> <td>Amount of time the job took to complete during the last run</td> </tr> <tr> <td><code>NEXT_RUN_DATE</code></td> <td><code>TIMESTAMP(6) WITH TIME ZONE</code></td> <td> </td> <td>Next date on which the job is scheduled to run</td> </tr> <tr> <td><code>SCHEDULE_LIMIT</code></td> <td><code>INTERVAL DAY(3) TO SECOND(0)</code></td> <td> </td> <td>Time after which a job which has not run yet will be rescheduled</td> </tr> <tr> <td><code>MAX_RUN_DURATION</code></td> <td><code>INTERVAL DAY(3) TO SECOND(0)</code></td> <td> </td> <td>Maximum amount of time for which the job will be allowed to run</td> </tr> <tr> <td><code>LOGGING_LEVEL</code></td> <td><code>VARCHAR2(4)</code></td> <td> </td> <td>Amount of logging that will be done pertaining to the job: <ul> <li> <p><code>OFF</code></p> </li> <li> <p><code>RUNS</code></p> </li> <li> <p><code>FULL</code></p> </li> </ul></td> </tr> <tr> <td><code>STOP_ON_WINDOW_CLOSE</code></td> <td><code>VARCHAR2(5)</code></td> <td> </td> <td>Indicates whether the job will stop if a window associated with the job closes (<code>TRUE</code>) or not (<code>FALSE</code>)</td> </tr> <tr> <td><code>INSTANCE_STICKINESS</code></td> <td><code>VARCHAR2(5)</code></td> <td> </td> <td>Indicates whether the job is sticky (<code>TRUE</code>) or not (<code>FALSE</code>)</td> </tr> <tr> <td><code>RAISE_EVENTS</code></td> <td><code>VARCHAR2(4000)</code></td> <td> </td> <td>List of job events to raise for this job. Possible values are: <ul> <li> <p><code>JOB_STARTED</code></p> </li> <li> <p><code>JOB_SUCCEEDED</code></p> </li> <li> <p><code>JOB_FAILED</code></p> </li> <li> <p><code>JOB_BROKEN</code></p> </li> <li> <p><code>JOB_COMPLETED</code></p> </li> <li> <p><code>JOB_STOPPED</code></p> </li> <li> <p><code>JOB_SCH_LIM_REACHED</code></p> </li> <li> <p><code>JOB_DISABLED</code></p> </li> <li> <p><code>JOB_CHAIN_STALLED</code></p> </li> <li> <p><code>JOB_OVER_MAX_DUR</code></p> </li> </ul></td> </tr> <tr> <td><code>SYSTEM</code></td> <td><code>VARCHAR2(5)</code></td> <td> </td> <td>Indicates whether the job is a system job (<code>TRUE</code>) or not (<code>FALSE</code>)</td> </tr> <tr> <td><code>JOB_WEIGHT</code></td> <td><code>NUMBER</code></td> <td> </td> <td>Weight of the job</td> </tr> <tr> <td><code>NLS_ENV</code></td> <td><code>VARCHAR2(4000)</code></td> <td> </td> <td>NLS environment of the job</td> </tr> <tr> <td><code>SOURCE</code></td> <td><code>VARCHAR2(128)</code></td> <td> </td> <td>Source global database identifier</td> </tr> <tr> <td><code>DESTINATION</code></td> <td><code>VARCHAR2(128)</code></td> <td> </td> <td>Destination global database identifier</td> </tr> <tr> <td><code>COMMENTS</code></td> <td><code>VARCHAR2(240)</code></td> <td> </td> <td>Comments on the job</td> </tr> <tr> <td><code>FLAGS</code></td> <td><code>NUMBER</code></td> <td> </td> <td>This column is for internal use.</td> </tr> </tbody> </table>
还没有评论，来说两句吧...