Sequence Issue

raja123 · Post by **raja123** » Mon Jun 16, 2008 7:47 pm

Hi All,

Given a job name, can I find out where the job is used in the sequence?

We are having a sequence, which is having around 1000 jobs and there are many recursive sequences.

There are many jobs which are not even used in the sequence. I need to find out if a job is used in the sequence or not. If yes, then where?

Thanks and Regards,
Surendra Kumar Sharma

vmcburney · Post by **vmcburney** » Mon Jun 16, 2008 8:06 pm

I think that in the DataStage Manager you can right click on a job and choose "Where Used" to find all the jobs that reference it. That might tell you which Sequence jobs it appears in.

ray.wurlod · Post by **ray.wurlod** » Mon Jun 16, 2008 8:26 pm

In version 7.x you click on "Usage Analysis" in Manager, having selected the job about which you are enquiring.

subrat · Post by **subrat** » Mon Jun 30, 2008 5:42 am

It seems that the samething u can achieve through DS_JOBS and DS_JOBOBJECTS table as well.

But not sure the join condition on these tables. Need to investigate.

Wait for sometime. Sure someone will post on it.

Thanks
Subrat

ray.wurlod wrote:In version 7.x you click on "Usage Analysis" in Manager, having selected the job about which you are enquiring. ...

chulett · Post by **chulett** » Mon Jun 30, 2008 7:23 am

Or just click on 'Usage Analysis'.