Collecting job metrics
You can run the following SQL queries on the Workload Scheduler data base to retrieve the number of jobs run by HCL Workload Automation over a period of time. One query determines the number of jobs run by specific workstations, while the other query determines the number of jobs run on the entire HCL Workload Automation domain. You can run the queries from the command line interface of your database or you can add them in the Dynamic Workload Console to create your custom SQL report tasks .