Collector for Background Job Monitoring
The technical name of the Collector for Background Job Monitoring is /DVD/MON_CL_COL_BG_JOBS.
This collector is used to monitor the performance and health of background jobs. It collects KPIs and details about the problematic jobs:
-
Failed background jobs
-
Jobs that have been running for too long
-
Jobs that should have already been started, but are still in a delayed state (not started jobs)
Default KPIs Delivered with This Collector
The following default KPIs are delivered with this collector:
|
KPI name |
Description | Unit |
Detail table |
|---|---|---|---|
| BTC_JOB_DELAY_TIME_TOTAL | BTC: Total delay of currently delayed jobs | Min | Yes |
| BTC_JOB_RUN_DUR_LONGEST_JOB | BTC: Duration of the longest-running job | Min | Yes |
| BTC_JOB_RUN_RUNTIME_TOTAL | BTC: Total runtime of currently running jobs | Min | Yes |
| BTC_MON_JOB_NUM_FAILED | BTC: Number of failed monitoring collector jobs | Count | No |
| BTC_NUM_DELAYED | BTC: Number of delayed background jobs ( >= 60 seconds) | Count | Yes |
| BTC_NUM_FAILED | BTC: Number of failed background jobs | Count | Yes |
| BTC_NUM_LONGRUN | BTC: Number of background jobs that have been running for too long ( >= 10 minutes) | Count | Yes |
| BTC_SLR_DELAY_RUNTIME_PERC | BTC: Delay/runtime for all jobs since last run | % | No |
| BTC_SLR_DELAY_S_PER_MIN | BTC: Total delay of all jobs per minute since last run | Sec | No |
| BTC_SLR_DELAY_S_TOTAL | BTC: Total delay of all jobs since last run | Sec | No |
| BTC_SLR_JOBS_NUM_COMPLETED | BTC: Number of all completed jobs since last run | Count | No |
| BTC_SLR_JOBS_NUM_NOT_STARTED | BTC: Number of all not started jobs since last run | Count | No |
| BTC_SLR_JOBS_NUM_STARTED | BTC: Number of all started jobs since last run | Count | No |
| BTC_SLR_JOBS_NUM_TOTAL | BTC: Number of all released and started jobs since last run | Count | No |
| BTC_SLR_JOBS_NUM_TOT_PER_MIN | BTC: Number of released and started jobs per minute since last run | Count | No |
| BTC_SLR_RUNTIME_S_PER_MIN | BTC: Total runtime of all jobs per minute since last run | Sec | No |
| BTC_SLR_RUNTIME_S_TOTAL | BTC: Total runtime of all jobs since last run | Sec | No |
Input Table
This collector uses the input table /DVD/MON_BGJOBI1.
The rules in this input table define the monitoring of custom and default KPIs. You can specify a job name pattern to filter specific jobs for KPI calculations or use a specific time threshold for delayed or long-running jobs, view the check type for the jobs, or enable/disable the collection of job details into the corresponding detail table. The input table provides the following fields:
| Technical name | Column name | Description |
|---|---|---|
| KPI | KPI name | Name of the KPI to which the rule appliesthat rule applies to |
| KPI_RULE_NUMBER | KPI rule number | KPI rule number |
| JOBNAME_PATTERN | BG job name pattern | Pattern for job names to which the rule applies |
| CHECK_TYPE | Background job check type |
Check type for background jobs. Possible values: • FINISHED • FAILED • RUNNING • DELAYED • LONGRUN |
| TIMELIMIT | Time limit for delayed and long-running BG jobs [s] | Time threshold in seconds for background jobs to be considered as delayed and long- running. |
| SID | System ID | System ID to which the rule appliesthat rule applies to |
| ADD_TO_DETAILS | Add relevant records to details | If set to X, details for the given KPI- related background jobs are reported into the detail table, o. Otherwise they are not reported. |
| ACTIVE | Is KPI rule active? | If set to X, the KPI rule is active. |
Parameters
The following parameters are used for this collector:
| Parameter name | Default value | Description |
|---|---|---|
| ONLY_NOT_STARTED_AS_DELAYED | X |
Defines which jobs are processed as delayed jobs for the default KPI BTC_NUM_DELAYED. If set to X, only jobs that have not started yet are included in this KPI. If set to <empty>, running or finished jobs within the last snapshot with a delayed time greater than the predefined threshold are included in this KPI. |
| ADD_TOP_X_JOBS_TO_DETAIL | 5 | Defines how many records for the top-X running and top-X delayed background jobs are reported in the detail table BTC top-X running and delayed jobs .By default, it reports 5 running jobs and 5 delayed background jobs, so the maximum number of reported records in this case is 10 in total. |
Detail Table
The collector provides two detail tables that store additional information about the monitored background jobs.
1. Monitored BTC jobs
The technical name of the detail table for Monitored BTC jobs is /DVD/MON_S_BTC_JOB_DETAILS. It reports details about the performance and health of the specified background jobs.
The detail table contains the following fields:
| Technical name | Description |
|---|---|
| TIMESTAMP | Time when the records are saved into the detail table |
| SID | System ID |
| JOBNAME | Background job name |
| JOBCOUNT | Background job ID number |
| CLIENT_CODE | Client |
| SERVER | Server name |
| JOBSTATUS | Background job status |
| DELAYED | Background job delay time [s] |
| LONGRUN | Background job long runtime [s] |
| JOB_START | Background job start time |
| JOB_END | Background job end time |
| CREATED_BY | Username of background job creator ’ |
| ERROR_MSG | Last error message from job log |
| KPI | KPI name |
| TIMELIMIT | Time limit for delayed and long-running background jobs [s] |
2. BTC top-X running and delayed jobs
The technical name of the detail table for BTC Top-X running and delayed jobs is /DVD/MON_S_BTC_TOP_JOBS_DET. It reports details about the top-X currently long-running jobs (only jobs that have been running for more than 5 minutes are reported in this detail table) and also the top-X jobs that are currently in a delayed state (not started as expected). The number of records that are reported in this detail table is defined by the collector parameter ADD_TOP_X_JOBS_TO_DETAIL.
The detail table contains the following fields:
| Technical name | Description |
|---|---|
| TIMESTAMP | Time when the records are saved into the detail table |
| SID | System ID |
| JOBNAME | Background job name |
| JOBCOUNT | Background job ID number |
| SERVER | Server name |
| CLIENT_CODE | Client |
| JOBGROUP | Summary of jobs for a group |
| JOBSTATUS | Background job status |
| JOBCLASS | Job classification |
| DELAYED_SEC | Background job delay time [s] |
| DELAYED_SEC | Background job long runtime [s] |
| SDLUNAME | Initiator of job/step scheduling |
| SDLDATE | Date of job/step scheduling |
| SDLTIME | Time of job/step scheduling |
| SDLSTRTDT | Planned start date for background job |
| SDLSTRTTM | Planned start time for background job |
| STRTDATE | Job start date |
| STRTTIME | Batch job start time |
