RE: IBM i Service: Job_Queue_Jobs

Why not use?

WRKJOBQ JOBQ(CM_MULTI)

Or TAATOOLS DSPJOBQ

The Display Job Queue command provides a display that is similar to
that provided by the system WRKJOBQ command except that only a single
job queue may be displayed and the user cannot perform actions
against the jobs. DSPJOBQ may be helpful if you have a menu oriented
system and want to prevent users from changing, holding, or ending
jobs on a job queue.

The intent of the command is that it would be used in place of
WRKJOBQ as an option on a user menu. It allows a user to see all the
jobs on the job queue sequenced by priority within status (released,
scheduled, or held). No command line exists.

A typical command would be:

DSPJOBQ JOBQ(QBATCH)

This displays the jobs that exist on the QBATCH job queue. The
subsystem the job queue is attached to (or *NONE) is shown at the top
of the display along with the status of the job queue. The display
that appears is similar to that provided by WRKJOBQ, but would only
allow the option to display more details about the job.

The APIs used include:

- QUSCRTUS
- QUSLJOB
- QUSRTVUS
- QUSRJOBI

Security considerations
-----------------------

In order to retrieve the information about jobs that are not the
users own, the RTVJOBAPI tool is used. This adopts the QSECOFR
profile while job information is being retrieved to allow for *JOBCTL
special authority. This provides the user with more authority than
he would receive from WRKJOBQ in terms of displaying information
about a job. If you feel this is too much information, make the
DSPJOBQ command private.

Paul

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Rob Berendt
Sent: Thursday, March 31, 2016 8:11 AM
To: midrange-l@xxxxxxxxxxxx
Subject: IBM i Service: Job_Queue_Jobs

Is there such an IBM i Service for DB2 which will list jobs on a job queue or queues?

I am thinking somewhere along the line of Active_Job_Info or Get_Job_Info.
And either List Job (QUSLJOB) API or the open list of jobs api.


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@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.