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
 

 

Need to filter jobs in the spool based on start time

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
hnharish

New User


Joined: 30 Aug 2005
Posts: 22

PostPosted: Wed Jan 18, 2012 12:24 pm    Post subject: Need to filter jobs in the spool based on start time
Reply with quote

Hello Team,

I am working on a requirement to filter the jobs based on start time. I am using the cmd "FILTER 'STA TIME' GE '6:15:58' " to filter the jobs but it is not getting filtered. I tried executing "AFD REFRESH" cmd after executing filter cmd but I am getting message "AFD MODE REQUIRED”. Please suggest.

If the above cmd runs successfully in spool then will try to implement in the jcl with SDSF program.

Thanks,
Harish.
Back to top
View user's profile Send private message

enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10210
Location: italy

PostPosted: Wed Jan 18, 2012 1:00 pm    Post subject: Reply to: Need to filter jobs in the spool based on start ti
Reply with quote

see this topic
http://www.ibmmainframes.com/viewtopic.php?t=54926&highlight=
for working examples of REXX scripts invoking SDSF
and the links to the redbook and tutorial on how to use the REXX SDSF smart interface
Back to top
View user's profile Send private message
hnharish

New User


Joined: 30 Aug 2005
Posts: 22

PostPosted: Wed Jan 18, 2012 3:12 pm    Post subject: Re: Reply to: Need to filter jobs in the spool based on star
Reply with quote

enrico-sorichetti wrote:
see this topic
http://www.ibmmainframes.com/viewtopic.php?t=54926&highlight=
for working examples of REXX scripts invoking SDSF
and the links to the redbook and tutorial on how to use the REXX SDSF smart interface


Thanks for the updates.

I would like to go with SDSF program. Please let me know the corrections in the filter cmd.

Regards,
Harish.
Back to top
View user's profile Send private message
enrico-sorichetti

Global Moderator


Joined: 14 Mar 2007
Posts: 10210
Location: italy

PostPosted: Wed Jan 18, 2012 3:22 pm    Post subject: Reply to: Need to filter jobs in the spool based on start ti
Reply with quote

Quote:
I would like to go with SDSF program. Please let me know the corrections in the filter cmd.

not me icon_biggrin.gif
I see no reason to waste time investigating the use of a dumb interface
when a smarter one is available ( especially for error handling and <not found> conditions )

here is a snippet which will filter jobs started between, ( find out Yourself )


Code:
 ****** ***************************** Top of Data ******************************
 000001 /*REXX - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - */
 000002 /*                                                                   */
 000003 /* - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - */
 000004 Trace  "O"                                                             
 000005 Parse Source _sys _how _cmd .                                           
 000006                                                                         
 000007 IsfRC = isfcalls("ON")                                                 
 000008 if IsfRC ¬= 0 then do                                                   
 000009     say "isfcalls RC" IsfRC                                             
 000010     exit                                                               
 000011 end                                                                     
 000012                                                                         
 000013 isfprefix     = "ENRICO*"                                               
 000014 isffiltermode = "AND"                                                   
 000015 isffilter     = "timee ge 17:00:00  timee le 18:00:00"                 
 000016 isfcols       = "jname jobid datee timee daten timen "                 
 000017                                                                         
 000018 Address SDSF "isfexec h  (alternate delayed"                           
 000019 if RC ¬= 0 then do                                                     
 000020     say "isfexec  RC" RC                                               
 000021     say isfmsg                                                         
 000022     do  m = 1 to isfmsg2.0                                             
 000023         say isfmsg2.m                                                   
 000024     end                                                                 
 000025     exit                                                               
 000026 end                                                                     
 000027                                                                         
 000028 do  j = 1 to jname.0                                                   
 000029     say right(j,2) jname.j jobid.j datee.j timee.j daten.j timen.j     
 000030 end                                                                     
 000031                                                                         
 000032 call  isfcalls "OFF"                                                   
 000033 exit                                                                   
 ****** **************************** Bottom of Data ****************************
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 -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Full Time COBOL Software Development ... shally Mainframe Jobs 0 Fri Jan 20, 2017 5:24 am
No new posts CICS transaction slow response time vasanthz All Other Mainframe Topics 1 Thu Jan 19, 2017 1:31 am
No new posts DD DUMMY & CPU TIME Nileshkul Testing & Performance analysis 16 Mon Dec 19, 2016 11:35 pm
No new posts Removing Duplicates based on certain ... chandracdac DFSORT/ICETOOL 8 Fri Dec 09, 2016 4:40 am
No new posts CICS START AND CANCEL blayek CICS 1 Wed Dec 07, 2016 3:27 am


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