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.

Regards,

Nanak.

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