Re: Gathering clock time for jobs executing throughthe day.

You can match it with msgID CPF1124 from the system log.

Both to different outfiles and join them on jobname/user/number.

You can do that with SQL but you have to use a lot of position scans.

I could send you some SQL statements that works like the way you want it
(as I interpret your request).

With regards,
Carel Teijgeler


*********** REPLY SEPARATOR ***********

On 3-8-2010 at 18:31 msmith6@xxxxxxxxxxxx wrote:

Is there a way without running something such as Performance Tools to

gather the wall clock time it takes jobs for a day to complete?

I printed the history log looking for CPF1164 but that's the execution

time, not wall clock.

For instance, I had a job that reported 8 seconds but entered the system

at 11:04 and ended at 11:06.

I would need to gather the information for the whole day.