Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

File aware jobs

Hi All,

I am using the below query to extract all the job chains which are event dependent.

"select jc.* from JobChain jc,JobDefinition jd,JobDefinitionWaitEvent jw"

                + " where jc.JobDefinition = jd.UniqueId"

                + " and jd.UniqueId = jd.MasterJobDefinition"

                + " and jd.UniqueId = jw.JobDefinition"

                + " and jd.UniqueId not in (select distinct JobChainCall.JobDefinition from JobChainCall)";

Can anyone please help me how to modify the above query to extract only file aware jobs.



Not what you were looking for? View more on this topic or Ask a question