Top level job definitions

[Former Member]

Hi All,

Can any one please help me with the query how to extract list of only Top Level master job definitions  excluding job chains and standard jobs.

Regards,
Chandu

[gmblom · Accepted solution]

select jd.* from JobDefinition jd

where jd.BranchedLLPVersion = -1 // only master job definitions

and jd.Behavior = 0                       // only custom job definitions

and not exists (select 1 from JobChain jc where jc.JobDefinition = jd.UniqueId) // no job chains

Regards Gerben

[Former Member · Accepted solution]

Thanks a lot Gerben

Regards,

Chandu