Re: Job Scheduler Task

[Jim Oberholtzer <midrangel@xxxxxxxxxx>]

Robert:

I know Jim answered the question directly but are you talking about the 
Advanced Job Scheduler Licensed Program Product ($$ albeit very small 
$$)  or the basic job scheduler that is shipped with the system?

If it is the Advanced version then look in library QUSRIJS for the 
files.  There you will find a file called QAIJSHST.  It has a good 
starting point for you.  As far as run times, you may need to dig that 
out of the history logs with the job identifiers that you find in QAIJSHST.

BTW:  This is pure systems administration, and I would argue advanced 
system administration.  Has very little to do with a DBA.

Jim Oberholtzer
Chief Technical Architect
Agile Technology Architects


On 9/8/2011 6:31 PM, Robert Munday wrote:
> Greetings from the sunny south.
>
>     My client has another task for me which is more suitable for a DBA than a
>     developer.  I have not worked with Job Scheduler.
>
>     My charge is to dump or review the statistics from the Job Scheduler
>     History and look for long-running jobs to determine if changes would
>     improve the throughput of the processes.  I found some*JS*  libraries
>     right before signoff this afternoon.  From what I saw the members were
>     programs and not files.  I have also briefly looked at the Midrange.com
>     archives and a few Google results.
>
>     Where would I need to look to find these history files?  Any tips on how
>     to determine the resource hogs?
>
>     Thanks,
>
>     Robert Munday
>     Munday Software Consultants
>     Montgomery, AL
>     on assignment in New Albany, OH