SQL Script - duration time

[lahansen]

Hi guy's,

I am looking for a SQL script that ca tell me:

jobname,
last start,
last end,
duration time,
avg. duration time

Anybody here that have such a SQL or a hint?


--
Lars

[fyot]

There is some SQL script.
From CONTROL-M Server database execute following SQL script

select JOBNAME, SCHEDTAB, ODATE, CYCLIC, CYCLICINT, STATE, STARTRUN, ENDRUN, NEXTTIME, MAXRERUN from CMR_AJF

From CONTROL-EM Server database
Find current ActiveNet using following SQL script.
There is an example of result: [ACTIVENET] = A060712001_A

and execute following SQL script

select JOB_NAME,ODATE, CYCLIC, INTERVAL, STATE, START_TIME, END_TIME,NEXT_TIME RERUN_COUNTER from [ACTIVENET]JOB

[lahansen]

thx Frank,

but I also need the job statistics, so I can see how long time the jobs runs - in the same way as I can se the job statistics in the GUI.

Ca you help with that too?

--
Lars

[fyot]

Hi Lars,

All statistics in the GUI come from CONTROL-M Server information.
You will found information in CMR_AJF, CMR_RUNINF and CMR_STATIS tables.

You will find all available fields in database poster in the download part of the site.