Export "Statistics" from mass jobs

A lot of scripts ans example to extract information from Control-M tools.
Post Reply
User avatar
rijuraha
Nouveau
Nouveau
Posts: 4
Joined: 09 Jun 2011 12:00

Export "Statistics" from mass jobs

Post by rijuraha » 25 Sep 2012 8:30

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.

User avatar
rijuraha
Nouveau
Nouveau
Posts: 4
Joined: 09 Jun 2011 12:00

Post by rijuraha » 27 Sep 2012 8:52

anyone?

User avatar
Vianney
Nouveau
Nouveau
Posts: 6
Joined: 30 Dec 2010 12:00

Post by Vianney » 03 Oct 2012 6:02

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

User avatar
Michaeljohn
Nouveau
Nouveau
Posts: 3
Joined: 04 Jul 2013 12:00

Post by Michaeljohn » 04 Jul 2013 9:51

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

User avatar
Nagarajan
Nouveau
Nouveau
Posts: 5
Joined: 14 Apr 2011 12:00
Location: Bangalore
Contact:

Post by Nagarajan » 15 Jul 2013 12:42

Any body have idea on how to get this done...
Nagarajan M S

User avatar
rajan
Nouveau
Nouveau
Posts: 3
Joined: 29 Feb 2008 12:00

CONTROL-M Utility Guide

Post by rajan » 25 Jul 2013 11:25

Please refer CONTROL-M Utility Guide ,,,

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

User avatar
nbarr007
Nouveau
Nouveau
Posts: 22
Joined: 30 Nov 2007 12:00

stats query

Post by nbarr007 » 06 Aug 2013 9:11

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, 8) as duration
from CMR_RUNINF
where timestmp like '20130513%'
AND SCHEDTAB LIKE 'PIPR%'
order by schedtab asc;

User avatar
markjosol
Nouveau
Nouveau
Posts: 3
Joined: 01 Nov 2013 12:00
Contact:

Post by markjosol » 01 Nov 2013 9:19

following below to fit your enviroment



________________________________________________
Fifa Ultimate Team CoinsFIFAUTC

Post Reply