It is currently 20 Sep 2017 11:53


Post new topic  Reply to topic  [ 4 posts ] 
Author Message
PostPosted: 07 Sep 2011 10:09 
Offline
Nouveau
Nouveau
User avatar

Joined: 07 Sep 2011 12:00
Posts: 1
Hi,

I am trying to add 1 more cloumn in my report to view the total time taken by each job. By default this is not included in the reporting facility. Can anyone help me out in achieving this requirement.

With regards
Shahab


Top
   
 Post subject:
PostPosted: 27 Sep 2011 6:39 
Offline
Nouveau
Nouveau
User avatar

Joined: 07 Jul 2008 12:00
Posts: 23
Report Facility has its limits. Use a SQL query to retrieve this information from either RUNINFO_HISTORY (EM database) or CMR_JOBINF (SV database).


Top
   
 Post subject:
PostPosted: 23 Feb 2012 11:16 
Offline
Nouveau
Nouveau
User avatar

Joined: 16 Feb 2012 12:00
Posts: 23
Keep up the good work.

_________________
dunya news


Top
   
 Post subject:
PostPosted: 27 Feb 2012 2:11 
Offline
Nouveau
Nouveau
User avatar

Joined: 14 Jan 2010 12:00
Posts: 58
Hi, I use this query to get run times. (found it on this forum a while back. :D )

select substring(TIMESTMP,1,8)as DATE,JOBNAME, cast((ELAPTIME/6000.00)as decimal(6,2)) as MINUTES
from CMR_RUNINF
where CMR_RUNINF.SCHEDTAB='name of scheduling group'
and CMR_RUNINF.TIMESTMP > 20100601000000
order by JOBNAME,TIMESTMP

Should be very easy to modify to meet your needs.

i


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

All times are UTC+02: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:  
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