Dear Experts, does anyone know how to select scheduled jobs ('S') that are using an old version of job definition? This jobs are displayed with a time stamp in jobmonitor column "Definition".
I used the below SQL-Statement but it gives to many results...
select * from Job j where j.Status = 'S' and j.JobDefinition in (select jd.UniqueId from JobDefinition jd where BranchedLLPVersion <> -1)