Statistic the jobs

futre25 · Post by **futre25** » 13 Apr 2011 2:16

Hi to all.

We have in new user daily at 07:00 h.

We want to get statistics for a job that runs from 03:30 h until 07:00, but I have no executions or table or with the command cmruninf. Why?

For other jobs if I have the statistics.
It may be because they are failing?

You have any query to get statistics of jobs (starun, endrun and status)?

EX:
ctmruninf -list "*" -JOBNAME "cfd660NT"
TIMESTAMP JOBNAME ORDERID RUN# NODEID MEMNAME MEMLIB CPU ELAPSED
-------------- ---------- -------- ---- ------------ ------------ -------------------- -------- ---------
20110413005820 cfd660NT 0000m8zw 1 sm00121 cfd660NT 2249.73 3186.00

but, for the job ctc200 its execution does not exist for day 13.

TIMESTAMP JOBNAME ORDERID RUN# NODEID MEMNAME MEMLIB CPU ELAPSED
-------------- ---------- -------- ---- ------------ ------------ -------------------- -------- ---------
20110412064527 ctc200 0000m8hg 14 clh_ma00 ctc200 0.00 10.76

Thanks to all.

futre25 · Post by **futre25** » 25 Apr 2011 4:40

Hi.

Any response please

Thanks to all.

nicke · Post by **nicke** » 05 May 2011 2:18

Hi!

I am not quite sure what you are out after....but one idea could be to run a SQL-script as a CTM-job just before New Day process starts at 07:00 hrs to catch the actual status of the particular job in the AJF with the query:

select JOBNAME,ORDER_TIME,STARTRUN,ENDRUN,STATUS from CMR_AJF where JOBNAME='ctc200';

Then you run this job daily and appending into a file and then you have the statistics for that particular job every day.....

philmalmaison · Post by **philmalmaison** » 05 May 2011 3:06

Hi,
Statistics are for jobs that ended successfully.
Regards,
Philmalmaison

futre25 · Post by **futre25** » 09 May 2011 5:06

Thanks you for your replica.

But, Where indicated (value) how many days or executions of statistics has a job. Is a predefined value can be modified. It is for all jobs the same or may be defined for each job.
We have day jobs with statistics of 20 days and cyclic jobs with only day statistics.

Thanks the new.