Applies to: SQL Agent Insight version 0.23

Job Monitor Overview

The Job Monitor is the primary location for doing the most common actions in SQL Agent Insight. Job Monitor will display all of the jobs being monitored for the particular instance of SQL Server and provides a vast number of actions that can be performed on a job or a set of jobs. Some of this functionality is unique to SQL Agent Insight and does not reside in the SQL Server Management Studio (SSMS). More on that later.

Dissecting the Job Monitor Window

Navigating around the Job Monitor window, like the remainder of SQL Agent Insight is intuitive. From the image at the right, we have the following major areas.

    • / / Expand / collapse filters pane
      • Shows / hides the filter pane. When the filter pane is collapsed and there are no filters selected, the icon will appear as an empty filter. Conversely, should there be at least one filter selected, the icon, when collapsed, will be solid in color. When the filter pane is expanded, the icon shown is a left arrow.

    • Clear selected filter(s)
      • Clears all filters on all columns with a single click.

    • Clear any / all groupings
      • Removes all columns put into the column header group drop area with a single click.

    • Size all columns to fit
      • Sizes all columns (with a single click) to the size of the maximum observed cell.

    • Show suspended / paused jobs
      • Suspending and resuming jobs automatically is unique to SQL Agent Insight. No other product at the time of this writing has a feature like this. Suspending a job will disable it for a given period of time, and then automatically enable the job after said time. This is ideal for jobs that do not need to be run, for example, during a maintenance window.
      • Should the suspend / resume controller jobs not be created on the monitored SQL instance, this button will prompt asking to create them.
      • Otherwise, if the suspend / resume controller jobs have already been created, pressing this button opens a new dialog showing jobs that have been suspended.

    • Remove custom suspend / pause jobs from server instance
      • For the suspend job feature to work, SQL Agent Insight requires two (2) controller jobs, one (1) schedule, and one (1) category created on the monitored instance of SQL Server. Pressing this button will remove those four items from the SQL instance.
        If there are jobs that are in a suspended state when the controller jobs are removed, the suspended jobs are put back to their original state as if they were resumed manually.

    • Reload data from server and refresh
      • Refreshes the entire Job Monitor main workspace by querying the server for updated data.

    • Allows a quick, one-click set of a filter for the jobs within the main datagrid. The filters include:
      • Enabled
      • Disabled
      • Idle
      • Not Idle (Running)
      • Has Schedule
      • No Schedule
      • Has Notifications
      • No Notifications
      • No Steps
      • Recently Created
      • Recently Modified
      • Last Run Success
      • Last Run Failure
      • Last Run Cancelled
      • Last Run Unknown
      • Never Run
      • Recently Failed
      • Recently Cancelled
      • Multiserver Type
      • Local Type
      • Enabled; No Notify
      • Enabled; No Schedule
      • Has History

    • Allows grouping the data against one or more columns. When grouping is applied, the data is organized into a hierarchical structure based on matching column values and it is sorted in ascending order.
    • To move a column header into the group drop area, left-click drag the desired column header and release in the group drop area.

    • This is the “meat and potatoes” of the Job Monitor. Depending on the monitored instance, this can show quite a bit of information per job and when all columns are visible, the following data for each job is shown:
      • Name
      • Status
      • Last Run Outcome
      • Success Rate
      • Last Run
      • Next Run
      • Has a Schedule
      • Number of Schedules
      • Number of Steps
      • Has Notifications
      • Created
      • Modified
      • Category
      • Running Duration
      • Requested By
      • Number of Historical Executions
      • Average Run Time
      • Maximum Run Time
      • Type
      • Number of TSX Targets

    • The row headers in the main workspace serve a dual purpose within the Job Monitor.
      1. The current state of the job in the row, either enabled or disabled, will be shown by a color, green and red respectively.
      2. For jobs that are actively suspended using SQL Agent Insight’s suspend/resume feature, a sleeping icon, will be shown.
      3. Jobs that are actively executing (i.e. running) will be shown with a running person icon.

    • Column headers contain the name of the column, but also may include the filter option. Clicking the filter icon will open a dialog allowing the grid data to be manipulated further, either showing less or more.

      When a filter has been created, the filter icon will change , indicating that a filter has been set for the specified column.

      To manually clear a columns filter, click on the filter icon and select the option “Clear Filter” from the resulting dialog.

      Column headers are also draggable, meaning, one can change the display order if desired.

      And lastly, column headers can be grouped by holding down the left mouse button and dragging the desired column to the group drop area located directly above the headers.

    • Located at the bottom left of the Job Monitor is the auto refresh toggle. Turning this on will refresh the Job Monitor automatically after the given number of seconds indicated. When enabled (active), a progress bar is shown indicating the amount of time that has passed and how much time remains prior to the next refresh.
A typical Job Monitor window with the major sections highlighted.
Click to enlarge.