Justin,

Do you know SQL? (just kidding, ducking and running...)

On 7.2

SELECT AUTHORIZATION_NAME, JOB_NAME, SUBSYSTEM, JOB_TYPE,
SERVER_TYPE
FROM TABLE(QSYS2.ACTIVE_JOB_INFO(
CURRENT_USER_LIST_FILTER => 'ROB')) X

....+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....
AUTHO00001 JOB_NAME SUBSYSTEM JOB_TYPE SERVE00001

ROB 977161/QTMHHTTP/ADMIN QHTTPSVR BCI
QIBM_HTTP_ADMIN
ROB 203207/ROB/ROBS1 QINTER INT -
******** End of data ********

http://www-01.ibm.com/support/knowledgecenter/ssw_ibm_i_72/rzajq/rzajqudfactivejobinfo.htm?lang=en-us

Notice how the first job listed does not have my name in the job name?

If you try this on 7.1
SQL0104 - Token => was not valid. Valid tokens: ) ,.

7.2 Knowledge Center has
IBM i 7.2>Database>Performance and query optimization>IBM i Services>Work
Management Services
7.1 stops at
IBM i 7.2>Database>Performance and query optimization

Check out the "What's new in DB2" on 12/15 offered free by COMMON.

Rob Berendt

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].