为提高效率，提问时请提供以下信息，问题描述清晰可优先响应。 【DM版本】: 【操作系统】：麒麟V10SP1 【CPU】:FT2000 【问题描述】*：如何查询作业运行历史信息?
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 *
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;