Link to home
Start Free TrialLog in
Avatar of Anthony
AnthonyFlag for United States of America

asked on

Is there anyway to generate a report, daily, of what is running in QBATCH and have it emailed out?

Does anyone know if there is a way to have a report sent out, daily, of what is running in QBATCH?  I'm assuming the responsibility of a couple of functions on an iSeries and it seems odd, that the current guy logs in every morning just to see if certain UIF printers are running.  I'd like a report sent out at like 5 AM that shows me the current status of those UIF printers.  

I can't purchase any other software, so I'd need to develop something in house or via the system i Navigator, if it is possible.

Thanks in advance.

-Anthony
Avatar of Theo Kouwenhoven
Theo Kouwenhoven
Flag of Netherlands image

You can list the active jobs with SQL, is that enough?
someting like:
SELECT JOB_NAME, SUBSYSTEM, SUBSY00001,
       AUTHO00001, JOB_TYPE, JOB_STATUS
  FROM TABLE(QSYS2.ACTIVE_JOB_INFO())  
 WHERE JOB_TYPE = 'WTR'                
 ORDER BY JOB_STATUS 

Open in new window

If that is not enough, you can combine it with scheduled job info
SELECT *  FROM QSYS2.SCHEDULED_JOB_INFO  

Open in new window

ASKER CERTIFIED SOLUTION
Avatar of Gary Patterson, CISSP
Gary Patterson, CISSP
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial