Quick Find doesn't find stage names
Posted: Wed Jun 11, 2014 10:44 am
I need to find jobs that use certain tables, but the table definitions are not imported into the repository. Instead, each table is coded in a Dynamic RDBMS stage with the stage name the same as the table name.
The problem is that neither Quick Find or Advanced Find is finding the jobs with the stage names even if I use wildcards around the name. When I do a manual hunt for the stages, I can see the stage name is set correctly in the Property Browser.
The easy solution would be to export the entire repository to a DSX file and search it outside of DS Designer, but alas the import and export security has been restricted.
Are DS_JOBS and DS_JOBOBJECTS queries my only option or is there some other way to find the stage names?
The problem is that neither Quick Find or Advanced Find is finding the jobs with the stage names even if I use wildcards around the name. When I do a manual hunt for the stages, I can see the stage name is set correctly in the Property Browser.
The easy solution would be to export the entire repository to a DSX file and search it outside of DS Designer, but alas the import and export security has been restricted.
Are DS_JOBS and DS_JOBOBJECTS queries my only option or is there some other way to find the stage names?