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

最新推荐文章于 2025-05-11 00:11:42 发布

ijwsoft

最新推荐文章于 2025-05-11 00:11:42 发布

阅读量2.8k

点赞数 1

CC 4.0 BY-SA版权

分类专栏：商业智能

本文链接：https://blog.youkuaiyun.com/keenweiwei/article/details/12496043

商业智能专栏收录该内容

20 篇文章

订阅专栏

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

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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'