It is currently 19 Jan 2019 11:09


Post new topic  Reply to topic  [ 2 posts ] 
Author Message
PostPosted: 21 Dec 2018 3:54 
Offline
Nouveau
Nouveau
User avatar

Joined: 02 Sep 2013 12:00
Posts: 6
Hi,

I'm running a ctm V7

I need to create a report at will that give status @present time like this :
Jobname | Description | Start Time | End Time | Run Time | (Status)

My problem is that controlm utilities like ctmstats / ctmjsa or ctmruninf truncate jobname to 10 Char and I need more char.

My other pb is that I am not an admin and have no access to ctmdb or emdb, and I should come with a solution that works without being able to test it.

So, here it is:
It should sound like
Select Jobname, startrun, endrun, elaptime from CMR_RUNINF where jobname like “Beginning*”

But I should also get field 'DESCRIPT' in the CMR_AJF table, and looking at the DB model, I think 'ORDERNO' field should do the jointure.


Can someone give me a query that works please?


Top
   
PostPosted: 27 Dec 2018 12:14 
Offline
Nouveau
Nouveau
User avatar

Joined: 26 Apr 2005 12:00
Posts: 724
Location: PARIS
Hi

I can suggest to see APSware Manager
Look this : aps-manager-for-control-m


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

All times are UTC+01:00


Who is online

Users browsing this forum: No registered users and 0 guests


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