Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

TWS jcl to retrieve job history

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IBM Tools
View previous topic :: :: View next topic  
Author Message
vd120

New User


Joined: 06 Nov 2010
Posts: 24
Location: NYC

PostPosted: Tue Mar 27, 2012 2:22 am    Post subject: TWS jcl to retrieve job history
Reply with quote

Hello,

does anyone knows if there is jcl I can run to retrieve report out of TWS about job history (I need job name and last time it ran). I have several hundreds of jobs and go to JH one by one not an option.

Thank you.
Back to top
View user's profile Send private message

PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2433
Location: Netherlands, Amstelveen

PostPosted: Tue Mar 27, 2012 10:42 am    Post subject:
Reply with quote

The TWS support people should know.
Back to top
View user's profile Send private message
David Robinson

Active User


Joined: 21 Dec 2011
Posts: 176
Location: UK

PostPosted: Tue Mar 27, 2012 5:05 pm    Post subject: Reply to: TWS jcl to retrieve job history
Reply with quote

Is the job still in the current plan?

Do you use the history function at your site?

Presumably you run the EQQDPRPT option with the EQQBATCH program as part of your daily planning. Check the SYSPRINT file from this step for details of all completed applications.
Back to top
View user's profile Send private message
vd120

New User


Joined: 06 Nov 2010
Posts: 24
Location: NYC

PostPosted: Tue Mar 27, 2012 6:01 pm    Post subject:
Reply with quote

I need report on all jobs we have in the TWS (regarding it running or not).
I want to clean up libraries (which was never done for last 20 years).

TWS support can not help me on this, a couple years ago IBM consultant setup job for them and no one touch it since.
Back to top
View user's profile Send private message
David Robinson

Active User


Joined: 21 Dec 2011
Posts: 176
Location: UK

PostPosted: Tue Mar 27, 2012 6:37 pm    Post subject:
Reply with quote

Your requirement is a little vague. You need to be more specific about exactly what you are tring to achieve. For a start, what libraries are you referring to? The TWS AD database, or the JCL / scrptlib libraries where your jobs reside?

Running the EQQYCAIN program with the following parameter will unload the entire AD database. You can then use this to work out which jobs are scheduled to run, although there is no record of the "last run" here.
ACTION=OPTIONS,BL=Y,BLPRT=Y,LTP=N;
ACTION=LIST,RESOURCE=ADCOM,STATUS=*,ADID=*.
Back to top
View user's profile Send private message
vd120

New User


Joined: 06 Nov 2010
Posts: 24
Location: NYC

PostPosted: Tue Mar 27, 2012 6:57 pm    Post subject:
Reply with quote

Thank you David, this sounds as starting point for me.

I think I need to refer to our JCL library, as this is one where all jobs got searched and maintained from, but I can work from database and run compare after. And I really need "last run" this will allow me to determine "dead wood". When I go to TWS job history it displays all occurences of the job executions with timestamp, so it is somewhere in the scheduler.
Back to top
View user's profile Send private message
David Robinson

Active User


Joined: 21 Dec 2011
Posts: 176
Location: UK

PostPosted: Tue Mar 27, 2012 7:03 pm    Post subject:
Reply with quote

I guess that's the history function then. Sorry, we don't use that so I'm not familiar with it. I know the history data resides in a DB2 table, so you could potentially bypass TWS and just run some SQL against it?
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> IBM Tools All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Detailed Transaction History report f... Kyle Carroll CICS 5 Tue Oct 18, 2016 12:42 am
No new posts Need to retrieve Julian_date Suganya87 DB2 4 Wed Aug 17, 2016 7:27 pm
No new posts Daily report to be extracted from CA ... polymathtarun DFSORT/ICETOOL 5 Mon Jul 11, 2016 4:33 pm
No new posts Syntax for running batch history repo... polymathtarun CA Products 1 Tue Jun 21, 2016 1:51 pm
No new posts Retrieve current year or month using ... vnktrrd DFSORT/ICETOOL 15 Tue Mar 15, 2016 4:14 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us