Page 1 of 1
List of stages in a job
Posted: Tue Jul 31, 2012 12:19 am
by dr.murthy
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
Posted: Tue Jul 31, 2012 12:36 am
by ray.wurlod
dsjob [ options ] -lstages projectname jobname
Wrap in a loop governed by dsjob [ options ] -ljobs projectname
Posted: Tue Jul 31, 2012 1:13 am
by dr.murthy
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
Posted: Tue Jul 31, 2012 2:17 am
by ray.wurlod
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.
Posted: Tue Jul 31, 2012 3:27 am
by vamsi.4a6
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
Posted: Tue Jul 31, 2012 5:48 am
by chulett
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.
Posted: Tue Jul 31, 2012 9:23 am
by BI-RMA
'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.
Posted: Tue Jul 31, 2012 3:46 pm
by ray.wurlod
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).