Rob,
Using a Halcyon Job Monitor, I created a monitor that ends any interactive job running for over 12 hours that meets the rule criteria.
Has been working without issue
User list . . . . . *JOBMNGT12 Interactive jobs GT 12 hours exclusion
Opt User Description
S *ALL All profiles selected.
O CPAMOBIL Service Account ICOMS Moblile App
Rule number . . . . . . . . 100 Interactive jobs signed on gt 12 ho
Rule type . . . . . . . . . *JOB *ASP, *JOB, *POOL..., F4=Prompt
Job name . . . . . . . . . O DSP01 S *ALL
Function type . . . . . . . *ALL *, CMD, DLY, GRP, I/O..., F4=Prompt
Function name . . . . . . . *ALL Name, generic*, *ALL
Job user . . . . . . . . . *JOBMNGT12 Name, generic*, *ALL..., F4=Prompt
Current user . . . . . . . *ALL Name, generic*, *ALL..., F4=Prompt
Subsystem . . . . . . . . . *ALL Name, generic*, *ALL
Status . . . . . . . . . *ALL *ACTIVE, *ALL
Job type . . . . . . . . . INTER Name, *ALL, *NONSBS, F4=Prompt
SLA statistic . . . . . . . *NO *YES, *NO
Open alert action . . . . . *DFT *DFT, *NONE, *ACK, *CLOSE
Statistic . . . . . . . . . RUNTIME CPUPCT, CPUTIME..., F4=Prompt
Comparison . . . . . . . . *GT *EQ, *NE, *LE, *GE, *LT, *GT, *IN
Value . . . . . . . . . . . 720 0-999999999
Paul
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxxxxxxxx] On Behalf Of Rob Berendt
Sent: Friday, March 29, 2019 9:20 AM
To: Midrange Systems Technical Discussion
Subject: Homegrown QINACTITV
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-%20UDTF
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
midrange.com
