Re: Routing Users Queries to Specific JOBQ other than their JOBD JOB

[Gary L Peskin <garyp@xxxxxxxxxxxx>]

Bill --

You might consider your own validity checking program on a copy of the
SBMJOB command which is in a library above QSYS on the system library
list.  You could examine the call stack and see if the SBMJOB was being
issued from the IBM AS/400 Query Menus and change the JOBQ to your
special job queue.

Validity checking programs are described in the OS/400 CL Programming
manual in the "Defining Commands" section.  BTW, be sure that the
library that your version of SBMJOB resides in has only *USE authority
and not *CHANGE or you could be in for some surprises.

To determine the parameters which will be passed to the validity
checking program, check out the RTVCMDSRC command on the News/400 web
site at http://www.news400.com

Also, be advised that this solution may require modifications when
moving to a new release of OS/400 if any of the SBMJOB parameters are
added or changed.

Gary

William N. Harrell, Jr. wrote:
> 
> We are searching for a way to route all user's Batch
> Submitted Queries to a specific Job Queue just for
> queries.  This Job Queue will be independent of the Job
> Queue specified in the user's Job Description.
> 
> i.e.  All other batch jobs go to their regular Job
> Queue, but when a Batch Query is submitted from the IBM
> AS400 Query Menues, the Query will go to another
> specifiec Queue so as not to intefere with processing in
> the other Queues.
> 
> Any ideas ?
> 
> Bill Harrell
> Systems Analyst
> Time Warner Cable
> Morrisville, N. C.
> 
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator: david@midrange.com
> +---
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---