Re: Checking a JOBQ to see if there are jobs waiting

[bdietz@xxxxxx]

Check out Feb '95 news/400.  there is a utility that is called WRKSBSJOBQ
within that code you can certainly
figure out how the api's work.



Bryan Dietz


                                                                                
                      
                    "Pryce Jones"                                               
                      
                    <jonesp@quinn-group        To:     
<MIDRANGE-L@midrange.com>                      
                    .com>                      cc:                              
                      
                    Sent by:                   Subject:     Checking a JOBQ to 
see if there are jobs  
                    owner-midrange-l@mi        waiting                          
                      
                    drange.com                                                  
                      
                                                                                
                      
                                                                                
                      
                    02/05/2001 11:57 AM                                         
                      
                    Please respond to                                           
                      
                    MIDRANGE-L                                                  
                      
                                                                                
                      
                                                                                
                      




Hi People,
After searching through the archives and not getting anywhere I wonder if I
can throw a problem passed you to see what we can come up with.
Problem: We have one jobq where loads of jobs are sent to and normally this
is fine for what we require. However, on occasion, the job that is running
from the jobq (we only allow one as there are dependencies) has either
stopped because of a msg (and the operations team have not spotted it) or
the job is running very slow and taking up all resources (perhaps a monster
query is running), etc, etc .... you get the idea - it is not something
that
we can normally forsee and program around. What I am looking to do is
something like throwing a "wrkjobq qbatch" to spool, doing a cpysplf to a
temp file and then retrieving the number of records. If over 2 then there
could be a problem so send msg to Me (not ops!). This is a "dirty" option
and there are a couple of prblems even with this solution. Has any one done
similar. :)
Thanx,
Pryce.



**********************************************************************
This email and any files transmitted with it are confidential and
intended solely for the use of the individual or entity to whom they
are addressed. If you have received this email in error please notify
the system manager.

This footnote also confirms that this email message has been swept by
MIMEsweeper for the presence of computer viruses.

www.mimesweeper.com
**********************************************************************
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@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 subscribe to this list send email to MIDRANGE-L-SUB@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
+---