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.
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.
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.