cancel
Showing results for 
Search instead for 
Did you mean: 

Count of Work flow and dataflow in a single job

Former Member
0 Kudos

Hi,

We would like to know the count of all the worlflow,dataflow which is present in a single job. Basically we want to know what are all the things are called in side the job and how many?

Is there any way to acheive this by seeing the repositary table or any other options are available?

So far we tried to count manually. If single job contains multiple workflow,dataflow,scripts and datastore. It is a very tough process to calculate this or find this. So if some one help us ton this ,It would be helpful for us to calculate the metrix.

Thanks,

Vino

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

You should be able to get this information by querying the repository. Look for the AL_USAGE table (or ALVW_PARENT_CHILD). The Reference Guide has a chapter on "Metadata in Repository Tables and Views" that explains how to use this table (with some sample SQL).

Answers (0)