|
View previous topic :: View next topic
|
| Author |
Message |
vd120
New User
Joined: 06 Nov 2010
Posts: 24
Location: NYC
|
|
|
|
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 |
|
 |
PeterHolland
Global Moderator
Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen
|
|
|
|
| The TWS support people should know. |
|
| Back to top |
|
|
David Robinson
Active User
Joined: 21 Dec 2011
Posts: 199
Location: UK
|
|
|
|
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 |
|
|
vd120
New User
Joined: 06 Nov 2010
Posts: 24
Location: NYC
|
|
|
|
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 |
|
|
David Robinson
Active User
Joined: 21 Dec 2011
Posts: 199
Location: UK
|
|
|
|
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 |
|
|
vd120
New User
Joined: 06 Nov 2010
Posts: 24
Location: NYC
|
|
|
|
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 |
|
|
David Robinson
Active User
Joined: 21 Dec 2011
Posts: 199
Location: UK
|
|
|
|
| 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 |
|
|
|
|
