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
|
EVENT_RULE VARCHAR2(65) FILE_WATCHER_OWNER VARCHAR2(65) FILE_WATCHER_NAME VARCHAR2(65) END_DATE TIMESTAMP(6) WITH TIME ZONE JOB_CLASS VARCHAR2(30) ENABLED VARCHAR2(5) AUTO_DROP VARCHAR2(5) RESTARTABLE VARCHAR2(5) STATE VARCHAR2(15) JOB_PRIORITY NUMBER RUN_COUNT NUMBER MAX_RUNS NUMBER FAILURE_COUNT NUMBER MAX_FAILURES NUMBER RETRY_COUNT NUMBER LAST_START_DATE TIMESTAMP(6) WITH TIME ZONE LAST_RUN_DURATION INTERVAL DAY(9) TO SECOND(6) NEXT_RUN_DATE TIMESTAMP(6) WITH TIME ZONE SCHEDULE_LIMIT INTERVAL DAY(3) TO SECOND(0) MAX_RUN_DURATION INTERVAL DAY(3) TO SECOND(0) LOGGING_LEVEL VARCHAR2(11) STOP_ON_WINDOW_CLOSE VARCHAR2(5) INSTANCE_STICKInesS VARCHAR2(5) RAISE_EVENTS VARCHAR2(4000) SYstem VARCHAR2(5) （编辑：甘南站长网） 【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容! |
