It is currently 22 Nov 2017 2:38


Post new topic  Reply to topic  [ 8 posts ] 
Author Message
PostPosted: 25 Sep 2012 8:30 
Offline
Nouveau
Nouveau
User avatar

Joined: 09 Jun 2011 12:00
Posts: 4
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.


Top
   
 Post subject:
PostPosted: 27 Sep 2012 8:52 
Offline
Nouveau
Nouveau
User avatar

Joined: 09 Jun 2011 12:00
Posts: 4
anyone?


Top
   
 Post subject:
PostPosted: 03 Oct 2012 6:02 
Offline
Nouveau
Nouveau
User avatar

Joined: 30 Dec 2010 12:00
Posts: 6
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


Top
   
 Post subject:
PostPosted: 04 Jul 2013 9:51 
Offline
Nouveau
Nouveau
User avatar

Joined: 04 Jul 2013 12:00
Posts: 3
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


Top
   
 Post subject:
PostPosted: 15 Jul 2013 12:42 
Offline
Nouveau
Nouveau
User avatar

Joined: 14 Apr 2011 12:00
Posts: 5
Location: Bangalore
Any body have idea on how to get this done...

_________________
Nagarajan M S


Top
   
 Post subject: CONTROL-M Utility Guide
PostPosted: 25 Jul 2013 11:25 
Offline
Nouveau
Nouveau
User avatar

Joined: 29 Feb 2008 12:00
Posts: 3
Please refer CONTROL-M Utility Guide ,,,

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


Top
   
 Post subject: stats query
PostPosted: 06 Aug 2013 9:11 
Offline
Nouveau
Nouveau
User avatar

Joined: 30 Nov 2007 12:00
Posts: 22
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;


Top
   
 Post subject:
PostPosted: 01 Nov 2013 9:19 
Offline
Nouveau
Nouveau
User avatar

Joined: 01 Nov 2013 12:00
Posts: 3
following below to fit your enviroment



________________________________________________
Fifa Ultimate Team CoinsFIFAUTC


Top
   
Display posts from previous:  Sort by  
Post new topic  Reply to topic  [ 8 posts ] 

All times are UTC+01:00


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
cron
Powered by phpBB® Forum Software © phpBB Limited
The site created by Franck YOT. Images, logo, content and trademarks about Control-M products are property of BMC Software.
All the comments are property of their posters. Images, logo, content and design are © copyright by Scheduler-Usage.com. All Rights Reserved