|How to get a job report with a query?
|Page 1 of 1|
|Author:||squee_75 [ 21 Dec 2018 3:54 ]|
|Post subject:||How to get a job report with a query?|
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?
|Author:||fyot [ 27 Dec 2018 12:14 ]|
|Post subject:||Re: How to get a job report with a query?|
I can suggest to see APSware Manager
Look this : aps-manager-for-control-m
|Page 1 of 1||All times are UTC+01:00|
|Powered by phpBB® Forum Software © phpBB Limited