RE: Capturing job log information on a text file

Oscar,

You can do a DSPJOBLOG OUTPUT(*FILE) to copy the joblog to a database file if a job is "running in
QBATCH". But of course if the job is still running you wont have an end time.

Also you can CPYSPLF to copy the spooled job log of a finished job to a database file.

Once the data is in a database file, you can use SQL, Query/400, or an RPG program to get the
information you want.

However, the question is, what exactly are you attempting to accomplish?

Are you looking for start/stop times for a specific job or all jobs? For what reason?

I guessing the performance monitors built into the operating system may better fits your needs.

HTH,
Charles

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Oscar Navas
Sent: Sunday, October 28, 2007 12:26 AM
To: midrange-l@xxxxxxxxxxxx
Subject: Capturing job log information on a text file

Hello.
I had sent the question included herein to be posted on RPG
400 programming to rpg400-l-owner@xxxxxxxxxxxx; however, it
got rejected since the moderator considered it had nothing to
do with RPG programming. Well, since they advised me to send
it to this forum, I am proceeding as suggested and hope this
time around it gets approved for posting. Thank you, in advance.
The message I would like to be posted is as follows:

Hello.
First of all, I am not a programmer, so what I'm looking for
is some sort of guidance with a project I have.
I know AS/400 from a user/administrative perspective but I
have been asked to come up with a way to export the start and
end times of jobs running in QBATCH subsystem to a flat file
that then can be exported to a document such as a spreasheet.
This is to reflect the times both start, end and the obtain
the elapsed time for a series of jobs that run in a daily basis.

Since I have no prior programming experience on RPG or COBOL
or the sort, I have no clue on how to do this (well, so maybe
someone can start by recommending me to study programming in
this environment but I would like to take that approach only
if necessary) I have tools such as the entire IBM ISeries
Access for Windows kit (That comes with a green screen 5250
emulator and Windows Navigator interface) but cannot seem to
find a way to do that here.
If I could only find a way to capture the start and end times
of jobs (from job log) and export that information to a
file, that's basically all I need.

Any one has any idea? Maybe someone can even refer me to a
proper forum.
Thanks a lot for any help.....In advance.

Regards,
Moris

rpg400-l-owner@xxxxxxxxxxxx
--
This is the Midrange Systems Technical Discussion
(MIDRANGE-L) mailing list To post a message email:
MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change
list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting,
please take a moment to review the archives at
http://archive.midrange.com/midrange-l.

This e-mail transmission contains information that is intended to be confidential and privileged. If you receive this e-mail and you are not a named addressee you are hereby notified that you are not authorized to read, print, retain, copy or disseminate this communication without the consent of the sender and that doing so is prohibited and may be unlawful. Please reply to the message immediately by informing the sender that the message was misdirected. After replying, please delete and otherwise erase it and any attachments from your computer system. Your assistance in correcting this error is appreciated.