Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Tip

By default, SQL Diagnostic Manager alerts on all Jobs. If you check the Alert on individual job steps box, all job steps generate alerts. Using the Include filter limits job alerts to only those SQL Server Agent Job steps that apply to the filter. The Exclude filter limits the job alerts to every SQL Server Agent Job step except for those included in the Exclude filter.

Image Added

The metrics that allow for SQL Server Agent Job exclusions include the following:

...

  1. Right-click a SQL Server instance in the Servers sidebar.
  2. Select Configure Alerts.
  3. Select the job-specific metric you want to edit from the list in the Alert Configuration window.
  4. On the Configuration tab, click Add.
  5. Specify or select the job name.
  6. Make the appropriate changes to your alert configuration for this job, and click OK. SQL Diagnostic Manager now displays the job in the list on the Configuration tab.

To Follow these steps to edit the alert threshold configuration for a job, follow these steps:

  1. Right-click a SQL Server instance in the Servers sidebar.
  2. Select Configure Alerts.
  3. Select the job-specific metric you want to edit from the list in the Alert Configuration window.
  4. On the Configuration tab, select the job you want to configure, and click Edit.
  5. Change the alerts thresholds by moving the arrows to the appropriate level or by entering new values of the threshold level on the Job Threshold Configuration window.
  6. Click OK.

...



Scroll pdf ignore
SQL Diagnostic Manager for SQL Server performance monitoring, alerting, and diagnostics for SQL Server.
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
|
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
|
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
|
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
|
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
|
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
|
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
|
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse