Re: SQL to get list of jobs running in a subsystem

[Jeff Young <jyoung0950@xxxxxxxxx>]

Kevin and Alan,
Thank you for the link.
I think that will provide me with the tool to extract the info I need.

Jeff Young
Sr. Programmer Analyst

On Wed, Apr 26, 2017 at 9:41 AM, Alan Shore <ashore@xxxxxxxx> wrote:

> Hi Jeff
> I have just recently been given this web page to look at
> I haven't had time to do a deep dive - but it might give you what you are
> looking for
>
> http://ibm.biz/DB2foriServices
>
>
>
> Alan Shore
> E-mail : ASHORE@xxxxxxxx
> Phone [O] : (631) 200-5019
> Phone [C] : (631) 880-8640
> 'If you're going through hell, keep going.'
> Winston Churchill
>
>
> -----Original Message-----
> From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
> Jeff Young
> Sent: Wednesday, April 26, 2017 9:35 AM
> To: midrange-l@xxxxxxxxxxxx
> Subject: SQL to get list of jobs running in a subsystem
>
> All,
> I know that I can use an API to get the list of jobs running in a
> subsystem, but is there an easy way using the new SQL procedures in 7.2 to
> get this information?
>
>
> Jeff Young
> Sr. Programmer Analyst
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
> unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
> moment to review the archives at http://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: http://amzn.to/2dEadiD
>
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: http://amzn.to/2dEadiD