oracle查看job运行,查看Oracle 定时Job 执行情况

SQL> SET LINESIZE 120;

SQL> COL job_name for A20;

SQL> SELECT   log_id,

2           job_name,

3           status,

4           TO_CHAR (log_date, 'DD-MON-YYY HH24:MI') log_date

5    FROM   dba_scheduler_job_run_details

6   WHERE   job_name = 'GATHER_STATS_JOB';

LOG_ID JOB_NAME             STATUS                         LOG_DATE

---------- -------------------- ------------------------------ ----------------------

75447 GATHER_STATS_JOB     STOPPED                        08-APR-011 06:00

75870 GATHER_STATS_JOB     STOPPED                        09-APR-011 06:00

77770 GATHER_STATS_JOB     STOPPED                        12-APR-011 06:00

73193 GATHER_STATS_JOB     STOPPED                        05-APR-011 06:00

69619 GATHER_STATS_JOB     STOPPED                        30-MAR-011 06:00

70698 GATHER_STATS_JOB     STOPPED                        01-APR-011 06:00

66689 GATHER_STATS_JOB     STOPPED                        24-MAR-011 06:00

63069 GATHER_STATS_JOB     STOPPED                        17-MAR-011 06:00

74768 GATHER_STATS_JOB     SUCCEEDED                      07-APR-011 04:39

70309 GATHER_STATS_JOB     STOPPED                        31-MAR-011 06:00

71489 GATHER_STATS_JOB     STOPPED                        02-APR-011 06:00

71627 GATHER_STATS_JOB     SUCCEEDED                      02-APR-011 09:48

74149 GATHER_STATS_JOB     STOPPED                        06-APR-011 06:00

76228 GATHER_STATS_JOB     SUCCEEDED                      09-APR-011 08:12

14 rows selected.