Page 1 of 1
Unix Command to list the stages in a job
Posted: Sun Aug 03, 2008 11:38 pm
by ramkarthik
Can anyone provide me the unix command to list all the stages in a job?
Posted: Sun Aug 03, 2008 11:55 pm
by ray.wurlod
dsjob -lstages ProjectName JobName
Posted: Mon Aug 04, 2008 9:04 am
by bcarlson
The only caveat is that the stage name that is returned is the one that you gave it. In other words, the list is only as good as your naming conventions. For example, if I named my DB2 read stage as 'george', the list command would show 'george', and I would not have anything to indicate WHAT george is.
We just had to generate a report recently of all of our DataStage projects, jobs, stages and stage info. We used the command Ray listed to generate a list of stages, then the following command to get a bit more details about the stage:
dsjob -stageinfo <project> <job> <stagename>
Brad.