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
SQL Script - duration time
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
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
Job statistics
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
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