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

　　 JOB_WEIGHT                                                     NUMBER
　　 NLS_ENV                                                        VARCHAR2(4000)
　　 SOURCE                                                         VARCHAR2(128)
　　 NUMBER_OF_DESTINATIONS                                         NUMBER
　　 DESTINATION_OWNER                                              VARCHAR2(128)
　　 DESTINATION                                                    VARCHAR2(128)
　　 CREDENTIAL_OWNER                                               VARCHAR2(30)
　　 CREDENTIAL_NAME                                                VARCHAR2(30)
　　 INSTANCE_ID                                                    NUMBER
　　 DEFERRED_DROP                                                  VARCHAR2(5)
　　 ALLOW_RUNS_IN_RESTRICTED_MODE                                  VARCHAR2(5)
　　 COMMENTS                                                       VARCHAR2(240)
　　 FLAGS                                                          NUMBER
　　

　　All Scheduler Job Run Details

　　You can monitor all scheduler jobs run details as follows.

　　select * from ALL_SCHEDULER_JOB_RUN_DETAILS;
　　

　　You can monitor dba scheduler running jobs as follows.

　　select * from dba_scheduler_running_jobs;
　　

　　You can monitor dba scheduler running jobs details as follows.

　　select * from dba_scheduler_job_run_details;
　　

　　You can run any scheduler jobs manually as follows.

　　begin
　　dbms_scheduler.run_job('JOB_NAME');
　　end;
　　/
　　

（编辑：甘南站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!

4/4

首页