Edit

Job Activity Monitor (Filter Settings)

  • Article

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