Page History

...

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 > >

...