Usage of routin in Job Sequence

[snassimr]

Hi !

If I use usage analysis I see the list of jobs used the routine . How about job sequences . How can I find out the job sequences use the denite routine ?

[roy]

Hi,
Ussage analysis was long reported as not 100% accurate to get this info and no fixes will be mad in it since MetaStage was introduced and is regarded as the tool to get this kind of info.

There for If you found any issue with this it will not be resolved.

I know it's not helping, sorry.

[kduke]

I have posted this code before. Replace :1 with your routine name in upper case. This is part of EtlStats. You can run this and have it email you the results by running job GenHtmlFromSqlDriver.

Parameters: (Take defaults on all but these)
SqlScriptsId = DsSearch1.sql
SqlDsn = localuv
SqlUser = leave blank
SqlPwd = leave blank
Replacements = YourRoutineNameInUpperCase

Code: Select all

SELECT 
   DS_JOBS.NAME AS JOB_NAME, 
   DS_JOBS.CATEGORY, 
   DS_JOBOBJECTS.NAME AS OBJECT_NAME, 
   DS_JOBOBJECTS.OLETYPE, 
   EVAL DS_JOBOBJECTS."if index(upcase(@RECORD),':1',1) > 0 then 'FOUND' else ''" AS FOUND FMT '5L'
FROM 
   DS_JOBS, 
   DS_JOBOBJECTS 
WHERE 
   DS_JOBS.JOBNO = DS_JOBOBJECTS.OBJIDNO 
   and FOUND = 'FOUND'
GROUP BY
   JOB_NAME, 
   DS_JOBS.CATEGORY, 
   OBJECT_NAME, 
   DS_JOBOBJECTS.OLETYPE, 
   FOUND
;

[snassimr]

Where I need to put the code ? Not Univers stage ,not routine as where

[kduke]

Do a search for TCL commands.

[snassimr]

when i run

SELECT
DS_JOBS.NAME AS JOB_NAME
FROM
DS_JOBS

the transform routine with tCL is hung up

Any ideas

[kduke]

You need to telnet into your DataStage server and connect to the Universe shell.