control-m中查找前置job和后置job

最新推荐文章于 2023-08-16 09:10:41 发布

原创最新推荐文章于 2023-08-16 09:10:41 发布 · 2.9k 阅读

7 ·

CC 4.0 BY-SA版权

商业智能专栏收录该内容

20 篇文章

订阅专栏

本文介绍了一种使用SQL查询来找出特定作业（PSIMED_MPI_MAINTENANCE）的后续作业和前置作业的方法。通过联接多个表并筛选条件，可以有效地获取到作业之间的依赖关系。

USE [CTRLM]
GO

-- Find Successors
SELECT JOBNAME,SCHEDTAB,* FROM CMR_AJF
WHERE ORDERNO IN (
SELECT C.ORDERNO FROM CMR_AJF A
INNER JOIN CMR_CON_J B ON A.ORDERNO=B.ORDERNO
INNER JOIN CMR_CON_J C ON C.ROWTYPE = 'I' AND B.CONDNAME=C.CONDNAME
WHERE  B.ROWTYPE='O' AND B.OP='+' AND A.JOBNAME='PSIMED_MPI_MAINTENANCE'
) AND TASKTYPE<>'G'

-- Find Predecessors
SELECT JOBNAME FROM CMR_AJF
WHERE ORDERNO IN (
SELECT C.ORDERNO FROM CMR_AJF A
INNER JOIN CMR_CON_J B ON A.ORDERNO=B.ORDERNO
INNER JOIN CMR_CON_J C ON C.ROWTYPE = 'O' and C.OP = '+' AND B.CONDNAME=C.CONDNAME
WHERE  B.ROWTYPE='I' AND A.JOBNAME='PSIMED_MPI_MAINTENANCE'
) AND TASKTYPE<>'G'