Checking the SPOOL for no of jobs using REXX

chinna · New User Joined: 04 Oct 2005 Posts: 5 Location: Hyderabad

Hi Group,....

I have requirement to check the SPOOl of all the team members to see how many jobs are present in their spool. For any member, if the no.of jobs exceed by a given number (say30), I need to send a email to that particular team member asking to delete unnecessary jobs in order to save space.

Now I am planning to automate the above process using REXX. I know how to send emails using rexx. But I was wondering how can I check the SPOOL of other members using REXX. All the jobs of a particular team member starts with his mainframe id. I am wondering if the SPOOL info is stored in any PS, so that I can get the info from it. If yes, plz tell me the name of that PS.

If any of you have any different approach for my requirement, please let me know, I would be greately thankful!!!

Regards,
Praveen.

ofer71 · Posted: Thu Mar 02, 2006 12:53 am

Hi -

What you need is SDSF in batch from within REXX. Please search this forum (and the "neighbour" forum) for examples I had posted in the past.

O.

amitava · Active User Joined: 30 Oct 2005 Posts: 186 Location: India

Hi Chinna,
I am sending u a sample code for monitoring the spool for a job - ISDXI42M.

Sathishk · New User Joined: 16 Feb 2006 Posts: 8

Hi Amit,

How can i know the return code of the job in rexx itself?

i.e

My requirement is I am submitting a job from rexx & based on its completion code (RC) I have to display a output file name created in that job. How this can be achieved?

Thanks

Sathish

amitava · Active User Joined: 30 Oct 2005 Posts: 186 Location: India

Hey Sathisk,
Whatever the code I have already sent in this post will do that thing.
However I am sending you the code for checking the return code. Ok! Just run the following REXX routine and then add the logic in your REXX routine to read the DS - AAAA.BBBB.CCCC(Here) and find out the return code.

martin9 · Posted: Thu Mar 09, 2006 8:56 pm

hy sathisk,
the above example is a very good one...
just change the filter command to filter
the OWNER parameter, because the job's name
can be of different name...

martin9

note: you can use any sdsf command, as you are used to do
yourself in online. sdsf batch is a simulated onlien session...

tarunsharma1981 · New User Joined: 18 Jul 2006 Posts: 1

Hi Everybody,

i also have a similar requirement in CMS, i want a way to check the return codes of steps in a job using REXX. Its more like running a rexx code to know whether a job ran fine or had any unacceptable returncode on a step.

Any help will be highly appreciated.

Huzefa · New User Joined: 05 Dec 2006 Posts: 83 Location: Bangalore

Hi all
I just don't want to save the spool output in the file, but insead put it in a stem.

How can I do that

Steve Coalbran · Posted: Mon Feb 12, 2007 1:05 am

Sounds like EXECIO might be what you're looking for ?!

Steve Coalbran · Posted: Mon Feb 12, 2007 1:19 am

of course I suspect SDSF doesn't run under CMS? (Les K?! are you on this forum - what does this function in VM/CMS ?)

Huzefa · New User Joined: 05 Dec 2006 Posts: 83 Location: Bangalore

Hi All
I tried with the below code to get the spool details for a particular jobname or jobid but None of the output got listed. Could anyone tell me why

/* REXX */
ADDRESS TSO
"ALLOC F(ISFIN) TRACKS SPACE(1) REU" /* USED BY SDSF */
"ALLOC F(ISFOUT) NEW DELETE REU " , /* USED BY SDSF */
"TRACKS SPACE(100,100) LRECL(133) RECFM(F,B,A) DSORG(PS)"
"ALLOC F(TEMPPRT) DA('NBDY8ZO.TEMP.JOB2') SHR"
JOBID = "JOB04056"
QUEUE "PRE NBDLBWU*" /* SDSF COMMANDS IN BATCH*/
QUEUE "ST"
QUEUE "FILTER JOBNAME " JOBID
QUEUE "PRINT FILE TEMPPRT" /* PRINT TO TEMP DATASET */
QUEUE "PRINT 1 999999"
QUEUE "PRINT CLOSE"
QUEUE "END"
QUEUE "EXIT"
"EXECIO" QUEUED()" DISKW ISFIN (FINIS" /* INPUT TO SDSF BATCH */
ADDRESS ISPEXEC "SELECT PGM(ISFAFD) PARM('++25,80')"/* INVOKE SDSF */
EXIT

thilakvs · New User Joined: 07 Aug 2007 Posts: 27 Location: chennai

by using this can i get CPU time from spool

kavya123 · New User Joined: 11 Jul 2007 Posts: 34 Location: hyderabad

Thilakvs,

By using the above code i am not able to get CPU time...

Could you please help.
I am getting the tempory dataset as an empty file.

thilakvs · New User Joined: 07 Aug 2007 Posts: 27 Location: chennai

Kavya,

I m also trying the same requirement..if i got the results i let u know..mean while if u got the result..let me know

kavya123 · New User Joined: 11 Jul 2007 Posts: 34 Location: hyderabad

Thilakvs,

For the below code pass JOBNAME JOBID as arguments.
also replace 'U153134.TEMP' with your own flat file(PS).
I have used this in two places in my code.

The 1st one is rexx exec and the next code is macro.
copy both of them in to different members and try.

thilakvs · New User Joined: 07 Aug 2007 Posts: 27 Location: chennai

Kavya,

Thanks a lot..but i m getting MCTIME NOT FOUND error..

how can i clear it..

kavya123 · New User Joined: 11 Jul 2007 Posts: 34 Location: hyderabad

Hi Thilakvs

I used IEF376I word in the macro which will be the last statement in JESYSMSG and it will give the CPU time as follows.

kavya123 · New User Joined: 11 Jul 2007 Posts: 34 Location: hyderabad

Hi Thilakvs,

Sorry for the confusion made by me...

MCTIME is the Macro(name which i have passed in the rexx exec to call macro)
So you please copy it in a member and save it as MCTIME.

The macro code was already provided to you.

kavya123 · New User Joined: 11 Jul 2007 Posts: 34 Location: hyderabad

Hi Thilakvs,
You can also use this code to find the CPU time
but as i already said 'U153134.TEMP' should be replaced by your own flat file.
It will be created at the begining and deleted automatically at the end.

Ajay Baghel · Posted: Mon Apr 07, 2008 6:46 pm

Hi,

When i execute the below rexx code, i am getting the error:

IKJ56701I Missing dataset name
IKJ56701I Missing name of dataset to be allocated.
IRX0555E The input or output file ISFIN is not allocated. It can not be opened for I/O.
IRX067OE EXECIO error while trying to GET or PUT a record.

expat · Posted: Mon Apr 07, 2008 7:16 pm

Take a look at http://www.ibmmainframes.com/viewtopic.php?t=20505

For CPU time I would suggest SMF records, which your performance and capacity people should already have the details that you might need.

Ajay Baghel · Posted: Mon Apr 07, 2008 10:20 pm

Sorry for putting you all in confusion:

I had by mistake added SHR to the line:
"

Ajay Baghel · Posted: Tue Apr 08, 2008 8:38 pm

Hi Friends,

kavya123 · New User Joined: 11 Jul 2007 Posts: 34 Location: hyderabad

Hi,

see i have included a delete statement at the end so that after reading the CPU time the PS created was deleted and after you use it second time for other jobname and job id new lines will be printed in the same PS.

Ashwin_mudikon · New User Joined: 03 Apr 2007 Posts: 32 Location: Chennai

Chinna,

Use outtrap funtion with the "STATUS" command. You will get the status of all the jobs in the stem that u ve given in the outtrap. stem.0 will be the no of jobs.