Re: Gathering clock time for jobs executing throughthe day.

["Carel Teijgeler" <coteijgeler@xxxxxxxxx>]

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.