How to List and Monitor DBMS Jobs and Scheduler Jobs in Orac
发布时间：2023-02-17 09:19:26 所属栏目：Oracle 来源：互联网
导读：I will explain How to List and Monitor DBMS Jobs and Scheduler Jobs in Oracle Database in this post. Monitoring Oracle Jobs There are two packages related with Oracle database jobs which are called dbms_job,dbms_scheduler. DBMS_SCHEDULER J
|
INSTANCE NUMBER sql> DBMS_SCHEDULER Jobs Monitor You can list and monitor the DBMS_SCHEDULER as follows. select * from dba_scheduler_jobs; You can list and view the log of DBMS_SCHEDULER as follows. select * from DBA_SCHEDULER_JOB_LOG; dba_scheduler_jobs view columns are as follows. sql> desc dba_scheduler_jobs; Name Null? Type ----------------------------------------------------- -------- ------------------------------------ OWNER VARCHAR2(30) JOB_NAME VARCHAR2(30) JOB_SUBNAME VARCHAR2(30) JOB_STYLE VARCHAR2(11) JOB_CREATOR VARCHAR2(30) CLIENT_ID VARCHAR2(64) GLOBAL_UID VARCHAR2(32) PROGRAM_OWNER VARCHAR2(4000) PROGRAM_NAME VARCHAR2(4000) JOB_TYPE VARCHAR2(16) JOB_ACTION VARCHAR2(4000) NUMBER_OF_ARGUMENTS NUMBER SCHEDULE_OWNER VARCHAR2(4000) SCHEDULE_NAME VARCHAR2(4000) SCHEDULE_TYPE VARCHAR2(12) START_DATE TIMESTAMP(6) WITH TIME ZONE REPEAT_INTERVAL VARCHAR2(4000) EVENT_QUEUE_OWNER VARCHAR2(30) EVENT_QUEUE_NAME VARCHAR2(30) EVENT_QUEUE_AGENT VARCHAR2(256) EVENT_CONDITION VARCHAR2(4000) （编辑：甘南站长网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
