HCL Workload Automation, Version 9.4

Job metrics queries for DB2 for zOS

Use the following SQL query to find the number of jobs run on specific workstations:
SELECT year(job_run_date_time) AS Year, month(job_run_date_time) AS Month, 
cast (count(job_run_date_time) AS INT) AS JobNbr FROM mdl.job_history_v 
WHERE workstation_name IN ('WKS_1', 'WKS_2', 'WKS_N')
GROUP BY year(job_run_date_time), month(job_run_date_time)
where 'WKS_1', 'WKS_2', 'WKS_N' are the names of the workstations that ran the jobs you want counted.
Use the following SQL query to find the number of jobs run on the entire HCL Workload Automation domain:
SELECT year(job_run_date_time) AS Year, month(job_run_date_time) AS Month, 
cast (count(job_run_date_time) AS INT) AS JobNbr FROM mdl.job_history_v 
GROUP BY year(job_run_date_time), month(job_run_date_time)