The SQL Server Agent Log alert indicates that specific text appeared in the SQL Server Agent error log. You can customize which text triggers this alert by using the Alert Filters tab on the Advanced Alert Configuration window.

The default settings are:

  • 2 - Warning
  • 1 - Critical

Use a size limit on your SQL Server Agent log

SQL Diagnostic Manager allows you to limit the size of your SQL Server Agent log to help improve response time and avoid using unnecessary space on your server. For additional information and steps on setting this limit, see Configure text and expression alerts.

Create an alert response bundle with the SQL Server Agent log alert and related alerts.  For additional information, see Create alert response bundles.



SQL Diagnostic Manager for SQL Server performance monitoring, alerting, and diagnostics for SQL Server.
IDERAProductsPurchase | Support | Community | Resources | About Us | Legal