SQL Diagnostic Manager allows you to determine the total time an alert is raised for an event occurring on a specified SQL Server instance. The Alert Duration tab of the Advanced Alert Configuration window provides a page for you to enter the duration of the alert in hours and minutes. For the SQL Server Agent Job Failure metric, you can specify whether you want SQL Diagnostic Manager to trigger the alert each time any job fails or to raise an alert only upon the failure of the most recently-executed job.

The metrics that allow for specifying alert duration include the following:

  • SQL Server Agent Job Completion
  • SQL Server Agent Job Failure
  • SQL Server Agent Long Running Job (Minutes)
  • SQL Server Agent Long Running Job (Percent)

To use ad hoc Alert Configuration to enter how long a job alert remains active:

  1. In the Navigation page, click Servers.
  2. Right-click the appropriate SQL server instance, and then select Configure Alerts.
  3. Select the metric for which you want to configure an alert.
  4. Click Advanced.
  5. Click Alert Duration.
  6. Type or use the selection window to enter the alert duration in hours and minutes.
  7. Click OK.
  8. To accept these changes, click OK.

To use Alert Configuration templates to enter how long a job alert remains active:

  1. Click Tools > Alert Configuration Templates.
  2. Click New or select an existing template, and then click View/Edit.
  3. If you clicked New, type a name, and then click Edit Configuration.
  4. If you clicked View/Edit, click Edit Configuration.
  5. Select the metric for which you want to configure an alert.
  6. Click Advanced.
  7. Click Alert Duration.
  8. If you selected the SQL Server Agent Job Completion, SQL Server Agent Long Running Job (Minutes), or SQL Server Agent Long Running Job (Percent) metric, continue with the next step. If you selected the SQL Server Agent Job Failure metric, select Anytime a job failure occurs to trigger an alert each time a job failure occurs or select Only if the most recent job execution failed if you want to raise an alert only when the most recently-executed job fails.
  9. Type or use the selection window to enter the alert duration in hours and minutes.
  10. Click OK.
  11. If you want SQL Diagnostic Manager to replicate your edits to every monitored SQL Server instance, click Yes.
  12. To accept these changes, click OK.


SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >