How do I access data from jobs that have finished running ?
Sujit Rekhi
We have ZEKE scheduler in our shop. I know it stores the information I need
as I am able to see it individually for a job.
Does it have any batch report facility that returns this information by
accepting a list of jobs ? Do you (or anybody on the list) know any such
facility in ZEKE ?
TIA
Sujit
-----Original Message-----
From: Robert Zenuk [mailto:Robz...@AOL.COM]
Sent: Wednesday, April 04, 2001 10:12 PM
To: TSO-...@VM.MARIST.EDU
Subject: Re: How do I access data from jobs that have finished running ?
There are several ways to approach this problem. All of them depend on the
tools available in your shop, the timing of your reporting requirements and
how much information about the job you want.
The most consistent and dependable way to get this information without fail
is from SMF data. Depending on which records your shop records (found in
SYS1.PARMIB member SMFPRMxx), you can extract this data from SMF record type
4 (step termination) and 5 (job termination) or the "newer" more accepted
type 30. This requires a process to dump your SMF ("online" VSAM data to
sequential files - usually a GDG) in a timeframe that is convenient to your
reporting requirements. Most shops tend to do this at least once a day (if
not more frequently due to volume). There are many tools to read and report
from SMF. Your shop probably already has at least one of them. See manual
OS/390 V2Rx.0 MVS System Management Facilities (SMF) GC28-1783-xx for
details.
In many shops SYSLOG is archived on a daily basis (usually to a GDG). It is
relatively easy to look for the IEF403I (job start) and IEF404I (job end)
messages for each of the jobs your are tracking. This can also be done in
batch using REXX or any SYSLOG analysis tool your shop may have. Since the
IEF403I and IEF404I messages are real consistent in columnar position, you
can even use SORT (and/or ICETOOL) to extract them and possibly a secondary
sort or REXX EXEC to extract your list of jobs after that... If you also
need step level detail, this technique is tougher to use. The sample
IEFACTRT exit in SYS1.SAMPLIB can stage additional step level information on
the SYSLOG, but summarizing it can be challenging.
In many shops, all production jobs are sucked out of the spool and saved in
a
Sysout Archive and Retrieval product (like RMDS, SAR, $AVRS, CONTROL-O,
etc).
Aside from being able to just read the detail from the saved JOBLOG, some
of
these extract the start and end time and store it in their report inventory
database. Many of these have batch interfaces and can store multiple
versions of each job/report. The batch interface may or may not have a
report writer or some usable canned report.
Job schedulers (JOBTRAC, ZEKE, OPC, CA-Scheduler, CA-7, etc) and rerun
managers (CA-11 - and I'm sure there are others) are another good source of
this information. Many times there are "tracking" files that contain
historical job/step start and end times as well a durations. Many of these
have batch utilities that may provide an off the shelf canned report or a
report writer that can help. Looking at the file/record layouts of these
files can also provide an opportunity to use the SORT suggestion from above.
Some MVS performance monitors keep historical files that may provide some of
this information. Many shops tend to only keep a few hours of this detail
though since it is also in SMF.
Hope this helps,
Robert Zenuk
robz...@aol.com
----------------------------------------------------------------------
For TSO-REXX subscribe / signoff / archive access instructions,
send email to LIST...@VM.MARIST.EDU with the message: INFO TSO-REXX
----------------------------------------------------------------------
For TSO-REXX subscribe / signoff / archive access instructions,
send email to LIST...@VM.MARIST.EDU with the message: INFO TSO-REXX
Auger, Richard C
we use Zeke here, and I do EXACTLY what you're after doing. I can
send you the complete job if you want (mail me off list), but basically I do
the following:
1) Run the ZEKEAUDT utility with sysin:
REPORT PRODUCT=ZEKE FILE=ZEKEAD1,LIMIT=2
REPORT PRODUCT=ZEKE FILE=ZEKEAD2,LIMIT=2
2) Run a rexx to create sort parm cards (so that you can set the date
that you want)
3) Run the sort to select just records with 'S', 'F', or 'SBOJ' status
4) (Optional) use ICETOOL to split the records by client ownership
5) Run another rexx to match up the starts/stops and create output file
- in my case I also format it for Excel.
6) E-mail results.
Didn't realise you were talking about Zeke, or I would have replied
earlier...
Richard
-----Original Message-----
From: Sujit Rekhi [mailto:Sujit...@INFY.COM]
Sent: Tuesday, 10 April, 2001 13:30
To: TSO-...@VM.MARIST.EDU
Subject: Re: How do I access data from jobs that have finished running ?
Thanks Robert. That was quite comprehensive.
We have ZEKE scheduler in our shop. I know it stores the information I need
as I am able to see it individually for a job.
Does it have any batch report facility that returns this information by
accepting a list of jobs ? Do you (or anybody on the list) know any such
facility in ZEKE ?
TIA
Sujit
----------------------------------------------------------------------
surend...@gmail.com
Im new to Zeke scheduler....I need a sample rexx/JCL program to get list of jobs which are running late status.
Pls provide sample program to get list of jobs thanks