Monitoring SQL Server Agent jobs
When SQL Server Agent monitoring is enabled, PATROL for Microsoft SQL Server monitors all SQL Server Agent jobs through the SQLAgentJobFailures parameter.
However, you can set up user-defined jobs in SQL Server so that they take advantage of the error log monitoring abilities of PATROL, and so that monitoring is more efficient and precise. For more information about how to set up SQL Server jobs, see Setting-up-SQL-Server-Agent-jobs-for-monitoring.
When the SQLAgentJobFailures (formerly SQLExecJobFailures) parameter goes into an alarm state, you can view SQLAgentJobFailures parameter output from a task output window or from the parameter annotation window. You can view information about all SQL Server Agent jobs and you can clear the alarm for the SQLAgentJobFailures parameter by choosing a KM menu item.
To perform these tasks, see the following topics:
- Viewing SQL Server Agent job information from PATROL
- Viewing failed job parameter output in a task window
- Viewing failed job parameter output in the annotation window
- Clearing-parameter-alarms-from-a-KM-menu
To monitor the error log for SQL Server Agent, see Monitoring-the-SQL-Server-error-logs.
Related topics