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
Sequence Issue
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
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.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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
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. ...