Skip to Content
0

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

Aug 09, 2017 at 07:09 AM

37

avatar image
Former Member

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers