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?
A lot of scripts ans example to extract information from Control-M tools.
2 posts • Page 1 of 1