Scheduler Usage
http://scheduler-usage.com/

How to get a job report with a query?
http://scheduler-usage.com/viewtopic.php?f=12&t=16397
Page 1 of 1

Author:  squee_75 [ 21 Dec 2018 3:54 ]
Post subject:  How to get a job report with a query?

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?

Author:  fyot [ 27 Dec 2018 12:14 ]
Post subject:  Re: How to get a job report with a query?

Hi

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
https://www.phpbb.com/