Check manual page of mssql_jobs
MSSQL Database: Jobs
| Distribution | Official part of Checkmk |
|---|---|
| License | GPLv2 |
| Supported Agents | Windows |
-job duration -MSSQL job status -outcome message -last run time -next run time
It is possible to set warn/crit levels for the job duration, in case the job or schedule is inactive, and/or corresponding to the MSSQL job status. Performance data is tracked in terms of job duration.
Parameters:
"Maximum run duration for last execution": Set state to WARN or CRIT when the job duration exceeds the levels provided.
"Job State": The state of the job is ignored when this parameter is set to "Ignore the state of the Job". This is the default behavior.
"Status of service in case of disabled job": The state that should be shown if the job or the schedule is disabled. The default state is OK.
"Status of service in case of missing job": The state that should be shown if the job is missing. The default state is CRIT.
This check needs the Checkmk mssql.vbs-plugin installed on the host. Please refer to the online documentation for instructions on how to install this plugin.
Item
The job name (optional), separated by {{.}}
Discovery
A seperate service is created for each job.