File aware jobs
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.