Where are the entries of the old AJF stored?

Post Reply
User avatar
Thommy
Nouveau
Nouveau
Posts: 1
Joined: 05 Dec 2013 12:00

Where are the entries of the old AJF stored?

Post by Thommy » 05 Dec 2013 6:07

I would like to read the ctm jobs of the last month from the database. What is the name of the correct table? In the table cmr_ajf i found the current jobs!!!

I need this information to create a monthly job statistic in COGNOS.
(number of executed jobs, number of jobs with status N, and so on....)

User avatar
Manii
Nouveau
Nouveau
Posts: 46
Joined: 28 Jul 2011 12:00

Post by Manii » 11 Dec 2013 11:20

Hi,

CMR_IOALOG_X where x is an number is the table which contain archived log data of AJF , however for a month it might not be there its depend on how many days you are keeping archive data.

for creation data which you have referred (number of executed jobs, number of jobs with status N, and so on....)

you can use reporting facility -- modify the report type TREND ANALYSIS to get these kind of data , by default there is 90 days statistics stored in Control-M for reporting facility .

Thanks,
Mani
:) :)

Post Reply