Job name which uses a particular routine

dstest · Post by **dstest** » Mon Oct 06, 2008 2:23 pm

Hi,

Is there any way I can find out If i give routine it will display all the jobs which are using that particular routine by using universe sql query.Give me the table names I can write a query my self.

Thanks
dstest

chulett · Post by **chulett** » Mon Oct 06, 2008 2:58 pm

Pretty much everything you'd ever want to know is in DS_JOBS and DS_JOBOBJECTS.

dstest · Post by **dstest** » Mon Oct 06, 2008 3:17 pm

I did a more reasearch on DS_JOBS and DS_JOBOBJECTS, but i did not find any information.I found one record in DS_JOBOBJECTS which is shwoing after routines.But i dont know how can i track if i used a routine in a transformer.

Can any one pelase give me your suggestions how to acheive this.

Thanks

chulett · Post by **chulett** » Mon Oct 06, 2008 3:31 pm

There's no published metadata for the repository tables, but a "LIST DICT tablename" might help. A little.

kduke · Post by **kduke** » Mon Oct 06, 2008 5:47 pm

viewtopic.php?t=99349&highlight=DsSearch1

dstest · Post by **dstest** » Mon Oct 06, 2008 7:46 pm

Hi Kim,

I tried that query and it is displaying all objects like link names,stage names but it is not giving routine names which i used in the transformer stage of job.

Thanks