Statistics

Nancy · Post by **Nancy** » 30 Jul 2009 4:45

Hi ,
Can you please tell me how to findout the run time of a job? i.e the exact time the job took to run..

Nancy

th_alejandro · Post by **th_alejandro** » 30 Jul 2009 6:38

In the GUI, you can select the job, then select 'statistics' and search your job id. Another way is selecting the job, select 'sysout' and view start/end time for the job. Another way is using SQL, accessing EM database and searching 'order_id' of the job, select fields start_time, end_time.

th_alejandro · Post by **th_alejandro** » 30 Jul 2009 6:40

I forget....the tablename for SQL is <tablecod>JOB.

Nancy · Post by **Nancy** » 04 Aug 2009 3:57

Thanks.

But i am looking for a report which should tell the job statistics of all the jobs not a single job?

Regards,
Saroj

control_win · Post by **control_win** » 04 Aug 2009 4:54

I think you could get that from the Reporting facility.

control_win · Post by **control_win** » 04 Aug 2009 5:24

This should be a much simpler option,

ctmstats -list <fromDate> <toDate>

Regards,
Wins.

philmalmaison · Post by **philmalmaison** » 05 Aug 2009 11:21

for run time use runinfo

CTMRUNINF usage:

ctmruninf -list <fromtime> <untiltime> [<filter>] [-total]
ctmruninf -delete <fromtime> <untiltime>
ctmruninf -purge

fromtime, untiltime : YYYYMMDDHHMMSS
filters : -JOBNAME <jobname>
-MEMNAME <memname>
-MEMLIB <memlib>
-NODEID <nodeid>
-ORDERID <orderid>
The <filter> parameter is optional.

-total : Prints number of records, total CPU & ELAPSED times

Example:
ctmruninf -list 19970121100000 19970121101900
ctmruninf -list "*"

regards
philmalmaison

Statistics

Statistics

In GUI and using SQL