Scheduler Usage

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....)

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