query which job is using aggregator stage in project?

him121 · Post by **him121** » Thu Nov 11, 2004 1:11 pm

hi..
i want to know which job is using aggregator stage in entire 500+ job
project..
can any one tell me that how can i do query on DS Admin...
or any other method which reduce my time..to search this..

thanx in adcance///

kduke · Post by **kduke** » Thu Nov 11, 2004 2:26 pm

You could almost guess it. Each stage type has a corresponding OLETYPE in DS_JOBOBJECTS.

Code: Select all

select
   distinct OLETYPE
from
   DS_JOBOBJECTS
;

Recently I posted a SQL query to join DS_JOBOBJECTS to DS_JOBS. If you cannot find it then ask. You need to get the job name from DS_JOBS. The JOBNO is the common field between the 2 tables.

Please post your solution when you figure it out.

vmcburney · Post by **vmcburney** » Thu Nov 11, 2004 4:58 pm

And if you do not want to do this in Universe you can also do it in the Reporting Assistant database (an Access database by default). The DSSTAGES table has a field called StageType and another called JobName. You can write your own Access query to get project and job names for the aggregator stage type.

crouse · Post by **crouse** » Thu Nov 11, 2004 5:43 pm

or... use the "Usage Analysis" in DS Manager.

Find the Aggregator Stage in the Stages folder, right click on Usage Analysis.

-Craig