Hi Guys,
There's a monitoring project needs to fetch the "statistics" data from 100s of jobs. They can't do it one by one by right click and selecting the option as the no of jobs is very high.
Please let me know if you have any alternative ideas which can be used here.

anyone?

Physical Data Model (search google) is your friend..... export via SQL once you found what you need (-which table-) contains the information you need...

http://www.google.fr/url?sa=t&rct=j&q=& ... gIczT2hHjg

http://www.google.fr/url?sa=t&rct=j&q=& ... dve4yBTztA

is your friend..... export via SQL once you found what you need (-which table-) contains the information you need...

_______________________________________________
WOW Gold|GW2 Gold|Aion Kinah|Diablo 3 Gold Kaufen

Any body have idea on how to get this done...

_________________
Nagarajan M S

Please refer CONTROL-M Utility Guide ,,,

ctmruninf -list <fromDate> <toDate> [<filter>] [-total]

You will need access to cmprd database to run the following script that will give you start time, end time and duration of a job

you will only need to change the following below to fit your enviroment

where timestmp like '20130513%'
AND SCHEDTAB LIKE 'PIPR%'


select distinct JOBNAME, schedtab
, to_char(to_timestamp(trim(timestmp)
, 'YYYYMMDDHH24MISS') - numtodsinterval(elaptime / 100
, 'SECOND'), 'YYYY-MM-DD HH24:MI:SS') as start_time
, to_char(to_date(trim(timestmp), 'YYYYMMDDHH24MISS')
, 'YYYY-MM-DD HH24:MI:SS') as end_time
, substr(to_char(numtodsinterval(elaptime / 100, 'SECOND')
, 'HH24:MI'), 12, as duration
from CMR_RUNINF
where timestmp like '20130513%'
AND SCHEDTAB LIKE 'PIPR%'
order by schedtab asc;

following below to fit your enviroment



________________________________________________
Fifa Ultimate Team Coins丨FIFAUTC