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

Anthony6890
Anthony6890 used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Theo KouwenhovenApplication Consultant

Commented:
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

Theo KouwenhovenApplication Consultant

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

Open in new window

VP Technology / Senior Consultant
Commented:
If the printers aren't running, what happens?  

Seems to be that instead of sending out a report (that requires manual review every day, and may require manual action to resolve if an issue is detected), it would be better to just create a little script (CL, SQL, QSH) that is scheduled to check the printer status, and take the appropriate action if they aren't running - like starting them.  Why create a document that needs to be reviewed and then requires manual action when you could just create a little script that just deals with the problem?

Or, even simpler, just set up a scheduled job that attempts to start the printers at 5am each day.  Create a two-line CL with the appropriate start commands in it, and set it up to run at 5am each day - or just add two schedule entries, each attempting to start one printer.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial