可使用 onstat -g dbc 命令监视正在运行的调度程序线程。可在 ph_run 表中查看有关已完成的任务和传感器的信息。
要查看有关当前正在运行的任务和传感器以及将运行的下一个任务或传感器的信息，请使用 onstat -g dbc 命令。
要查看有关已完成的任务和传感器的信息，请查询 sysadmin 数据库中的 ph_run 表。 必须以用户 gbasedbt 或其他授权用户身份连接 sysadmin 数据库。
Worker Thread(0) 46fa6f10
=====================================
Task: 47430c18
Task Name: mon_config_startup
Task ID: 3
Task Type: STARTUP SENSOR
Last Error
Number -310
Message Table (gbasedbt.mon_onconfig)
already exists in database.
Time 09/11/2007 11:41
Task Name mon_config_startup
Task Execution: onconfig_save_diffs
WORKER PROFILE
Total Jobs Executed 10
Sensors Executed 8
Tasks Executed 2
Purge Requests 8
Rows Purged 0
Worker Thread(1) 46fa6f80
=====================================
Task: 4729fc18
Task Name: mon_sysenv
Task ID: 4
Task Type: STARTUP SENSOR
Task Execution: insert into mon_sysenv select 1, env_name,
env_value FROM sysmaster:sysenv
WORKER PROFILE
Total Jobs Executed 3
Sensors Executed 2
Tasks Executed 1
Purge Requests 2
Rows Purged 0
Scheduler Thread 46fa6f80
=====================================
Run Queue
Empty
Run Queue Size 0
Next Task 7
Next Task Waittime 57
以下输出显示 ph_run 表中四个调度程序作业的历史记录：SELECT * FROM ph_run; RUN_ID 1 RUN_TASK_ID 2 RUN_TASK_SEQ 1 RUN_RETCODE 0 RUN_TIME 2009-07-20 13:04:59 RUN_DURATION 0.131850300007433 RUN_ZTIME 1248109468 RUN_BTIME 1248109468 RUN_MTIME 1248109499 RUN_ID 2 RUN_TASK_ID 3 RUN_TASK_SEQ 1 RUN_RETCODE 0 RUN_TIME 2009-07-20 13:04:59 RUN_DURATION 0.120845244247991 RUN_ZTIME 1248109468 RUN_BTIME 1248109468 RUN_MTIME 1248109499 RUN_ID 3 RUN_TASK_ID 4 RUN_TASK_SEQ 1 RUN_RETCODE 0 RUN_TIME 2009-07-20 13:04:59 RUN_DURATION 0.00254887164461759 RUN_ZTIME 1248109468 RUN_BTIME 1248109468 RUN_MTIME 1248109499 RUN_ID 2087 RUN_TASK_ID 7 RUN_TASK_SEQ 742 RUN_RETCODE 0 RUN_TIME 2009-09-09 11:09:51 RUN_DURATION 0.00489335523104662 RUN_ZTIME 1248109468 RUN_BTIME 1248109468 RUN_MTIME 1252508991