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 ?
Usage of routin in Job Sequence
Moderators: chulett, rschirm, 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.
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.
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
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
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
;
Mamu Kim