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, timmr@xxxxxxxxxx
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 <vhamberg@xxxxxxxxxxxxxxx>
Sent by: "JAVA400-L" <java400-l-bounces@xxxxxxxxxxxxxxxxxx>
To: Java Programming on and around the IBM i
<java400-l@xxxxxxxxxxxxxxxxxx>
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: JAVA400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: [1]https://lists.midrange.com/mailman/listinfo/java400-l ;
or email: JAVA400-L-request@xxxxxxxxxxxxxxxxxx
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/