The Add Job Filter or Edit Job Filter window allows you to create or edit a filter to determine when you want a SQL Server Agent job condition to raise an alert.
To access the Add Job Filter or Edit Job Filter window:
SQL Server Agent Job Completion
SQL Server Agent Job Failure
SQL Server Agent Long Running Job (Minutes)
SQL Server Agent Long Running Job (Percent)
The Job Filters tab allows you to include or exclude a job by job category, name, or step name if you check Alert on individual job steps .
To add a job filter:
Enter the value to filter the job for in the Value field or click the Browse button to browse for the object you want to filter.
Use the percent symbol (%) as a Wildcard. |
Click OK.
The Browse button is only available when adding or editing job step filters for a single SQL Server instance. |
SQL Diagnostic Manager identifies and resolves SQL Server performance problems before they happen. Learn more > >
|