List of stages in a job

dr.murthy · Post by **dr.murthy** » Tue Jul 31, 2012 12:19 am

Hi All,

I have an small requirement to identify the list of the stages that used in a jobs across the project.

is there any way to achieve this ?? instead of doing the manual process, since i have a more than 5000 jobs.

Thanks in advance

ray.wurlod · Post by **ray.wurlod** » Tue Jul 31, 2012 12:36 am

dsjob [ options ] -lstages projectname jobname

Wrap in a loop governed by dsjob [ options ] -ljobs projectname

dr.murthy · Post by **dr.murthy** » Tue Jul 31, 2012 1:13 am

Thanks ray,

I just wanted to generate a report which contain list of the job names and folder where the pivot stage was used.
can i get this info by using above ds command

ray.wurlod · Post by **ray.wurlod** » Tue Jul 31, 2012 2:17 am

No. But, then, I answered the question you asked.

The new question has an even easier answer. Select the Pivot stage in the Repository and perform a "where used" analysis (also known as an "impact" analysis). DataStage itself will give you your list.

vamsi.4a6 · Post by **vamsi.4a6** » Tue Jul 31, 2012 3:27 am

IF you followed naming conventions for Jobs and Stages in a Project.You can filter Using grep command after finding the stages in a Job

@RAY

Please let me know "where used" analysis option in Datastage Repositary

chulett · Post by **chulett** » Tue Jul 31, 2012 5:48 am

Naming conventions? Ha!

Where Used was (and I assume still is) a toolbar icon that becomes active when an object is selected. It looks like a flask from a chemistry set from what I recall. Might even be a right-click option now for all I know. Really shouldn't be all that hard to find.

BI-RMA · Post by **BI-RMA** » Tue Jul 31, 2012 9:23 am

'Where used" is also one of the options available within Advanced Find (The magnifier-glass-icon on the tool-bar). There are diverse other options available there.

ray.wurlod · Post by **ray.wurlod** » Tue Jul 31, 2012 3:46 pm

chulett wrote:Naming conventions? Ha!

Where Used was (and I assume still is) a toolbar icon that becomes active when an object is selected. It looks like a flask from a chemistry set from what I recall. Might even be a right-click option now for all I know. Really shouldn't be all that hard to find.

The flask icon was only in the Manager client, which no longer exists. These days it's ONLY a right click option.

For this particular question naming conventions are irrelevant - the usage is being reported for the stage type irrespective of how it's named. It can be called directly via right click on the stage type - it doesn't have to be called from within Advanced Find (though that works too).