How to find all jobs that use database stage as ref link

Marley777 · Post by **Marley777** » Thu Sep 27, 2012 12:26 pm

Thanks for reading. How to find all jobs that use database stage as reference link. Looking for a search of somekind. Any help is greatly appreciated.

ArndW · Post by **ArndW** » Fri Sep 28, 2012 2:10 am

If you go to your designer, navigate the repository to

Stages Types -> Parallel -> Database -> {your stage type}

then right-mouse-click and "find where used"

you will get a list of jobs where that stage is used.

Marley777 · Post by **Marley777** » Fri Sep 28, 2012 6:38 am

Thanks for your response...

but we need to know where db2 stages are used as 'reference links' and not where the db2 stage is used anywhere in a job. So we are looking for a specific scenario where the db2 stage is used...in this case used as a reference link. Any help is greatly appreciated. Thanks.

ArndW · Post by **ArndW** » Fri Sep 28, 2012 7:32 am

I can't think of a way to get this with a quick click method.

With a small DS/BASIC routine you could loop through all jobs, and in each job loop through all links, and then find those which have a passive stage at the source end and print those out where the stage type is db2.

Marley777 · Post by **Marley777** » Fri Sep 28, 2012 7:42 am

Thanks for the reply. We'll try this.