RE: Query status of spool file in outqueue

   Greetings.  Yea. the Javatool box, or jtopen has a lot of options, and you
   can and should be able to access everything you mention below, and then
   you would have to call to remove things.  There are no automated ways in
   the toolbox to clean up spool files.
    
   BUT, with the very latest IBM i Services, there is a new service that may
   be of interest. A new services was delivered in the SYSTOOLS library that
   allows you to specify the outQ, user and date for spool files that you
   want to delete from the system, and this service will clean them up for
   you. 
    
   Here is an example of that SQL 
    
   call Systools.Delete_Old_Spooled_Files(Delete_Older_Than =>
      current date - 30 days, P_User_Name => 'TIMMR',
      Preview => 'YES')
   Latest database Group will provide you with this nifty feature. 
    
   Tim

   Tim Rowe, [email protected]
   Business Architect Application Development & Systems Management for IBM i
   IBM i ISV Council
   IBM i Development Lab, Rochester, MN
   (507) 253-6191 (Tie) 553-6191

   http://www-03.ibm.com/systems/power/software/i/are/index.html
   http://ibm.biz/IBMi_ACS
    
    

     ----- Original message -----
     From: Vernon Hamberg <[email protected]>
     Sent by: "JAVA400-L" <[email protected]>
     To: Java Programming on and around the IBM i
     <[email protected]>
     Cc:
     Subject: [EXTERNAL] Re: Query status of spool file in outqueue
     Date: Tue, May 19, 2020 9:54 AM
      
     Cool!

     The answer to the first is probably yes - there are variations of what I
     sent that should give you what you want - google for it.

     as for the Java toolkit, as I understand it, you can do just about
     anything with it. You'd probably want some command to run, so see what
     functions are there for running commands. Another Google for you to do,
     right?

     HTH
     Vern

     On 5/19/2020 8:27 AM, maxbobzien--- via JAVA400-L wrote:
     > Perfect, thanks!
     >
     > Is there also a way to check for out queues that are in status MSGW?
     > And does the Java toolkit offer any options to delete spool files in
     SENDING status or clear out queues in MSGW status?
     >
     > Max
     --
     This is the Java Programming on and around the IBM i (JAVA400-L) mailing
     list
     To post a message email: [email protected]
     To subscribe, unsubscribe, or change list options,
     visit: [1]https://lists.midrange.com/mailman/listinfo/java400-l 
     or email: [email protected]
     Before posting, please take a moment to review the archives
     at [2]https://archive.midrange.com/java400-l .

     Help support midrange.com by shopping at amazon.com with our affiliate
     link: [3]https://amazon.midrange.com 
      

    

References

   Visible links
   1. https://lists.midrange.com/mailman/listinfo/java400-l
   2. https://archive.midrange.com/java400-l
   3. https://amazon.midrange.com/
-- 
This is the Java Programming on and around the IBM i (JAVA400-L) mailing list
To post a message email: [email protected]
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/java400-l
or email: [email protected]
Before posting, please take a moment to review the archives
at https://archive.midrange.com/java400-l.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com