Re: How to map a HTTP service with it's servicing iSeries job

Maybe you can change one of the example in ACS RUNSQLScripts

-- category: IBM i Services
-- description: Work Management - Active Job info - SQL Server Mode study
--
-- Find active QSQSRVR jobs and the owning application job

WITH Tt(Authorization_Name
,Job_Name
,Cpu_Time
,Total_Disk_Io_Count)
AS (SELECT Authorization_Name
,Job_Name
,Cpu_Time
,Total_Disk_Io_Count
FROM TABLE(Qsys2.Active_Job_Info(Subsystem_List_Filter => 'QSYSWRK', Job_Name_Filter
=> 'QSQSRVR')) X)
SELECT Authorization_Name
,Ss.Message_Text
,Job_Name
,Cpu_Time
,Total_Disk_Io_Count
FROM Tt
,TABLE(Qsys2.Joblog_Info(Job_Name)) Ss
WHERE Message_Id = 'CPF9898'
AND From_Program = 'QSQSRVR'
ORDER BY Cpu_Time DESC;


Bryan


Steurbaut, Richard wrote on 8/3/2018 3:21 PM:

We want to know, how to map a HTTP service with it's servicing iSeries job.

What we know?
- HTTP services runs under QUSRWRK subsystem.
- QZRCSRVS is the job name.
- User is same as the user who created the server. (There could be multiple
services in a server and one HTTP service can be serviced by multiple
iSeries jobs)

But to identify the job which is servicing the particular HTTP service, we
have to check all the jobs having the above attributes.

Is there a better way to find out the exact iSeries job related to a HTTP
service.

Any valuable input will be highly appreciated.