Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers