How to get a job report with a query?

A lot of scripts ans example to extract information from Control-M tools.
Post Reply
User avatar
squee_75
Nouveau
Nouveau
Posts: 6
Joined: 02 Sep 2013 12:00

How to get a job report with a query?

Post by squee_75 » 21 Dec 2018 3:54

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?

User avatar
fyot
Nouveau
Nouveau
Posts: 736
Joined: 26 Apr 2005 12:00
Location: PARIS
Contact:

Re: How to get a job report with a query?

Post by fyot » 27 Dec 2018 12:14

Hi

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

Post Reply