Skip to Content
0
Former Member
Aug 09, 2017 at 07:09 AM

how to select scheduled jobs ('S') that are using an old version of job definition

102 Views Last edit Aug 09, 2017 at 07:10 AM 2 rev

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)

09-08-2017-08-57-48.png

Attachments