Siebel SQLs/Error Messages >  Find all repeated jobs from WfProcMgr and WfProcbatchMgr

Find all repeated jobs from WfProcMgr and WfProcbatchMgr

The SQL is

SELECT DISTINCT
evt.OBJ_NAME,
evt.EVT_NAME,
evt.EVT_SUB_NAME,
actset.NAME,
act.SVC_NAME,
act.SVC_METHOD_NAME,
act.SVC_CONTEXT
FROM
S_CT_EVENT evt
JOIN S_CT_ACTION_SET actset ON actset.ROW_ID = evt.CT_ACTN_SET_ID
JOIN S_CT_ACTION act ON act.CT_ACTN_SET_ID = actset.ROW_ID
WHERE
-- evt.EVT_SUB_NAME = 'EventMethodNBSMCheck'
act.SVC_CONTEXT LIKE '%Workflow Name%'
ORDER BY evt.OBJ_NAME, act.SEQ_NUM