Page 1 of 1

search for a value passed to parameter in whole repository

Posted: Wed Oct 19, 2011 7:02 pm
by nsm
Hi,

a table in our database is loaded by multiple jobs and are unknown to us as we just acquired the system.

I need to search for a particlar value passed for this parameter and find out the culprit jobs.

Can you please let me know if there is a way to do it?

Thanks
nsm.

Posted: Wed Oct 19, 2011 7:14 pm
by ray.wurlod
Probably search through an export file of the project for the parameter name.

Posted: Wed Oct 19, 2011 9:16 pm
by eostic
Are you looking for the "value" that might have been passed to a parameter, without knowing the parameter or the job name? A Metadata Workbench query can do that, "if" you were collecting Operational Metadata for the particular Jobs in question....

Ernie

Posted: Mon Nov 07, 2011 9:33 am
by emblem_user
Hi,

I know the parameter and I have the value that's been passed to it but I don't know the job where its been passed.

I need to find out the job where that value is been passed.

Thanks
nsm.