Unix Command to list the stages in a job

ramkarthik · Post by **ramkarthik** » Sun Aug 03, 2008 11:38 pm

Can anyone provide me the unix command to list all the stages in a job?

ray.wurlod · Post by **ray.wurlod** » Sun Aug 03, 2008 11:55 pm

dsjob -lstages ProjectName JobName

bcarlson · Post by **bcarlson** » Mon Aug 04, 2008 9:04 am

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.