Datastage jobs Using Oracle Table

pavan_test · Post by **pavan_test** » Fri Feb 11, 2011 9:40 am

Can anyone please suggest me how do I find out the list of all datastage jobs using a particular oracle table say "employee".

Thanks
Mark

kumar_s · Post by **kumar_s** » Fri Feb 11, 2011 9:57 am

If you had saved the metadata in the repository, you can do the Usage Analysis based on the Table Defenition.

pavan_test · Post by **pavan_test** » Fri Feb 11, 2011 10:05 am

actually we havne't saved the meta data for this particular table. There are round 500 datastage jobs in the project. So trying to find out if there is any way I can use sql to query and find out list of all datastage jobs using a particular oracle table.

chulett · Post by **chulett** » Fri Feb 11, 2011 10:44 am

Not sure how much of this will still work in the 8.x world but do an exact search here for "OLETYPE" and go from there.

ray.wurlod · Post by **ray.wurlod** » Fri Feb 11, 2011 1:45 pm

Learn from the experience. Always manage your metadata rigorously.