Re: Message queue QSYS/QSYSMSG

So I was just looking into this. If you're on V7R2 or higher you can use
SQL to query message queues.

I would think this would be pretty easy to then monitor for messages. It's
still something I can add to JOBWATCH if Jim or others are interested, but
with simple SQL it seems it can be done fairly easily.

Message queues are never fun to deal with, but this really simplifies
things. Here's the article I found:
http://www.rpgpgm.com/2017/05/using-sql-for-message-queue-data.html

Let me know if I am off base here... :) Again I'm happy to add this
feature, but I would use the SQL method as I recall the APIs for message
queues were not fun to work with. That means V7R2 or higher (with the
appropriate PTFs, Refresh, etc).

Bradley V. Stone
www.bvstools.com
MAILTOOL Benefit #22 <https://www.bvstools.com/mailtool.html>: Cost
starting at under $300 a year per partition!

On Thu, Sep 28, 2017 at 11:40 AM, Bradley Stone <bvstone@xxxxxxxxx> wrote:

I will dig into it, Jim. It gives me a reason to move JOBWATCH up to
V7R1, if that's not an issue. I still have my V5R4 devo box I could do it
on. :) I do have many customers on old OS versions.

Bradley V. Stone
www.bvstools.com
MAILTOOL Benefit #20 <https://www.bvstools.com/mailtool.html>: The
ability to specify multiple email routers/relays to make sure emails are
sent when they need to be.

On Thu, Sep 28, 2017 at 8:09 AM, Jim Oberholtzer <
midrangel@xxxxxxxxxxxxxxxxx> wrote:

Brad,

I like the idea. Might push me over the top to put this on all my
customer
machines.....


--
Jim Oberholtzer
Agile Technology Architects

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Bradley Stone
Sent: Wednesday, September 27, 2017 10:32 AM
To: Midrange Systems Technical Discussion
Subject: Re: Message queue QSYS/QSYSMSG

I've been meaning to add this to my JOBWATCH application. It already
monitors for MSGW (or any status) job and also can make sure at least "X"
jobs are running. This would be a cool addition.

Bradley V. Stone
www.bvstools.com
MAILTOOL Benefit #1 <https://www.bvstools.com/mailtool.html>: Command and
ILE Interfaces available which means easily sending email from your
programs.