Skip to Content

Monitoring the SQL Server Agent job failures

The SQLServerAgentJobFailures parameter monitors all SQL Server jobs, and goes into an alarm state whenever any step in a job fails at any point during the job.

You can use the MSSQLServer/SQLServerInstanceName/ResetJobFailureAlarm pconfig variable to clear the SQLAgentJobFailures parameter alarm automatically at the start of each polling cycle. For more information about this variable, see Agent-configuration-variables.

When the SQLServerAgentJobFailures parameter goes into an alarm state, it automatically creates an output window that contains information about SQL Server Agent job failures. This parameter also generates annotated data points in the parameter graph that provide reports about the job failures. Double-click any annotated data point to open a report in an annotation output window.

You can use the /MSSQLServer/SQLServerInstanceName/JobStepFailFlag pconfig variable to check a job step failure. If the value of this variable is set to 1, every job step failure will alarm. For more information about this variable, see Agent-configuration-variables.

You can view information about all SQL Server Agent jobs by using the Reports > SQL Server Agent Job Failures menu command from the Server application pop-up menu.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*

BMC PATROL for Microsoft SQL Server 9.5