Scheduler Usage
http://scheduler-usage.com/

Export "Statistics" from mass jobs
http://scheduler-usage.com/viewtopic.php?f=12&t=3261
Page 1 of 1

Author:  rijuraha [ 25 Sep 2012 8:30 ]
Post subject:  Export "Statistics" from mass jobs

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.

Author:  rijuraha [ 27 Sep 2012 8:52 ]
Post subject: 

anyone?

Author:  Vianney [ 03 Oct 2012 6:02 ]
Post subject: 

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

Author:  Michaeljohn [ 04 Jul 2013 9:51 ]
Post subject: 

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

Author:  Nagarajan [ 15 Jul 2013 12:42 ]
Post subject: 

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

Author:  rajan [ 25 Jul 2013 11:25 ]
Post subject:  CONTROL-M Utility Guide

Please refer CONTROL-M Utility Guide ,,,

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

Author:  nbarr007 [ 06 Aug 2013 9:11 ]
Post subject:  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, 8) as duration
from CMR_RUNINF
where timestmp like '20130513%'
AND SCHEDTAB LIKE 'PIPR%'
order by schedtab asc;

Author:  markjosol [ 01 Nov 2013 9:19 ]
Post subject: 

following below to fit your enviroment



________________________________________________
Fifa Ultimate Team CoinsFIFAUTC

Page 1 of 1 All times are UTC+01:00
Powered by phpBB® Forum Software © phpBB Limited
https://www.phpbb.com/