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.
Export "Statistics" from mass jobs
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
http://www.google.fr/url?sa=t&rct=j&q=& ... gIczT2hHjg
http://www.google.fr/url?sa=t&rct=j&q=& ... dve4yBTztA
- Michaeljohn
- Nouveau
- Posts: 3
- Joined: 04 Jul 2013 12:00
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
_______________________________________________
WOW Gold|GW2 Gold|Aion Kinah|Diablo 3 Gold Kaufen
CONTROL-M Utility Guide
Please refer CONTROL-M Utility Guide ,,,
ctmruninf -list <fromDate> <toDate> [<filter>] [-total]
ctmruninf -list <fromDate> <toDate> [<filter>] [-total]
stats query
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;
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
________________________________________________
Fifa Ultimate Team Coins丨FIFAUTC