Get job names being called in Sequencer

atulgoel · Post by **atulgoel** » Thu Oct 04, 2012 3:24 am

Hi,

I want to know all the jobs being called in a sequencer and save the result in a notepad or excel sheet.

I can view all the jobs dependent on a sequencer through "Job dependency" but How to save it in a notepad?

ray.wurlod · Post by **ray.wurlod** » Thu Oct 04, 2012 3:34 am

Do you mean all the jobs designed to be called in the sequence, or the jobs actually called when the sequence runs (which may not be all of the jobs in the design, depending on the sequence's logic)?

The first is most easily accomplished by querying the DS_JOBOBJECTS table.
The second is most easily accomplished by reading the "summary of sequence run" in the sequence's job log.

atulgoel · Post by **atulgoel** » Thu Oct 04, 2012 3:45 am

Hi Ray,

I mean all the jobs designed to be called in the sequence. I want the job names in a notepad.

Thanks

chulett · Post by **chulett** » Thu Oct 04, 2012 7:22 am

Do an exact search for DSSEARCH here, I think that will get you on the road to a solution.