Job Activity Monitor (Filter Settings)
Applies to: SQL Server
Use this page to reduce the number of rows visible in the Job Activity Monitor. Enter criteria in one or several of the available boxes, to show only the rows that meet the specified values. Some of the boxes, such as Status or Blocking Type offer a finite number of possible values, provided by a dropdown list. Others, such as Application, allow you to enter whatever value and as many values as you wish, as a comma separated list. Toolbar icons allow you to sort the available boxes by category or alphabetically. Select the criteria to show a short description of each one.
To filter the Job Activity Monitor, provide as many filter criteria as you want, select Apply filter, and then select OK.
All Jobs
This group of filter criteria is available when filtering the Job Activity Monitor.
Name
Filter jobs by name.
Next Run
Filter by the date next scheduled to run.
Runnable
View jobs that can be run, or jobs that can't be run. Select Yes to view only jobs that can be run, select No to view only jobs that can't be run, or select All to view both jobs that can be run, and jobs that can't.
Last Run
Filter by the date last run.
Last Run Outcome
Filter jobs by the status last time the jobs were run.
Enabled
View only enabled or not enabled jobs
Category
Filter jobs by the job category.
Scheduled
View all jobs with schedules, or without schedules.
Status
Filter jobs by the status.
Description Area
Description Box
This unnamed box provides a short description of the criteria as they are selected.
Apply filter
To apply the filter, select Applyfilter and then select OK. To retain the filter settings in the FilterSettings dialog box, but not apply them, uncheck Applyfilter, and then select OK, to display all rows.
Clear
Returns the filter settings back to the default settings.
See also
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for