Fetching job info

[koolnitz]

Hi,

We have 100+ jobs in our project. Recently we discovered that we have used (unintentionally) Basic Transformers instead of Parallel Transformers in few of the jobs. We do not know which jobs are victim of this. As per my knowledge, we can check for the type of Transformer being used by generating reports of the jobs. It would be very cumbersome to generate reports for all the jobs.

Is there any quickest way to find out which jobs in my project are using Basic Transformer stages?

Thanks in advance!

[kduke]

This is the SQL you can run at TCL. You will have to limit it to the link type of BASIC. You will need to figure that out for yourself.

Code: Select all

SELECT 
   DS_JOBOBJECTS.OLETYPE as LinkType, 
   DS_JOBS.NAME as JobName, 
   DS_JOBOBJECTS.NAME as LinkName, 
   DS_JOBS.CATEGORY as Category
FROM 
   DS_JOBOBJECTS,  
   DS_JOBS 
WHERE  
   OBJIDNO = JOBNO 
   and DS_JOBS.CATEGORY = 'whatever' 
Group by 
   LinkType, 
   JobName, 
   LinkName, 
   Category
;

[koolnitz]

Found another way to see which jobs have used Basic transformer stages (or any other stages):

Go to DS Manager,
Select Stage Types -> parallel -> processing -> Basic Transformer -> Right click and select usage analysis.