Page 1 of 1
query which job is using aggregator stage in project?
Posted: Thu Nov 11, 2004 1:11 pm
by him121
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///
Posted: Thu Nov 11, 2004 2:26 pm
by kduke
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.
Posted: Thu Nov 11, 2004 4:58 pm
by vmcburney
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.
Posted: Thu Nov 11, 2004 5:43 pm
by crouse
or... use the "Usage Analysis" in DS Manager.
Find the Aggregator Stage in the Stages folder, right click on Usage Analysis.
-Craig