RE: Homegrown QINACTITV

Thank you.
Submitted a RFE to add how long a job has been sitting at DSPW to ACTIVE_JOB_INFO
http://www.ibm.com/developerworks/rfe/execute?use_case=viewRfe&CR_ID=131533


-----Original Message-----
From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Bryan Dietz
Sent: Friday, March 29, 2019 9:24 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
Subject: Re: Homegrown QINACTITV

The one I wrote utilized the Inactivity timer system value. I had the messages sent to a message queue that was monitored by a never-ending-program.
That program makes decision on whose job to end.
Its not perfect as the messages are sent based on when the SBS started. And not actual clock time for inactivity.


Bryan

On Mar 29, 2019, at 8:19 AM, Rob Berendt <rob@xxxxxxxxx> wrote:

Let's say you're not ready to take the leap on QINACTITV. Is there anything in the following which will tell you how long it has been sitting in DSPW?
Select
JOB_NAME,
AUTHORIZATION_NAME,
job_active_time, a.*
from table(qsys2.active_job_info(
RESET_STATISTICS => 'NO',
SUBSYSTEM_LIST_FILTER => 'QINTER' ,
JOB_NAME_FILTER => '*ALL',
CURRENT_USER_LIST_FILTER => '',
DETAILED_INFO => 'ALL'
)) A
where job_type<>'SBS'
and job_status='DSPW'
ORDER BY JOB_ACTIVE_TIME
;
https://www.ibm.com/developerworks/community/wikis/home?lang=en#!/wiki
/IBM%20i%20Technology%20Updates/page/QSYS2.ACTIVE_JOB_INFO%28%29%20-%2
0UDTF

Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To
subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at
https://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: https://amazon.midrange.com

--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives at https://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: https://amazon.midrange.com