查看作业信息：
SELECT A.ID,A.NAME,A."ENABLE",A.USERNAME,A.CREATETIME,A.MODIFYTIME,A.DESCRIBE,
B.LAST_DATE||' '||B.LAST_SEC LAST_TIME,B.NEXT_DATE||' '||B.NEXT_SEC NEXT_TIME,B.WHAT
FROM SYSJOB.SYSJOBS A,SYSJOB.USER_JOBS B
WHERE A.ID=B.JOB;

查看作业调度信息：
SELECT * FROM SYSJOB.SYSJOBSCHEDULES;
作业运行历史信息
SELECT *
FROM SYSJOB.SYSSTEPHISTORIES2 A
WHERE (SELECT COUNT(*)
FROM SYSJOB.SYSSTEPHISTORIES2 B
WHERE B.NAME = A.NAME
AND B.EXEC_ID >= A.EXEC_ID) <= 10
ORDER BY A.START_TIME DESC,A.NAME;

--查询执行情况
select NAME,STEPNAME,START_TIME,END_TIME,ERRCODE,ERRINFO from SYSJOB.SYSSTEPHISTORIES2 order by START_TIME desc;
--查看作业信息

select ID,NAME,ENABLE,USERNAME,CREATETIME,VALID,DESCRIBE from SYSJOB.SYSJOBS;

--查看步骤信息

select ID,NAME,JOBID,SEQNO,TYPE,COMMAND from SYSJOB.SYSJOBSTEPS;

select ID,NAME,JOBID,SEQNO,TYPE,FAIL_ACTION from SYSJOB.SYSJOBSTEPS;