SQL Agent Insights:Documentation:Job History Overview

Back to Documentation Main

---

Accessing the Job History window can be done via Job Monitor, by right-clicking on a job and selecting View Job History.

A typical Job History window.

Key Sections

Tool/Action Bar

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.

Size all columns to fit

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

Purge job history

• Opens the purge job history dialog.

Reload data from server and refresh

• Refreshes the entire Job Monitor main workspace by querying the server for updated data.

Filter Pane

• Allows a quick, one-click set of a filter for the items within the main datagrid. The filters include:
  • Hide Job Steps - hides all job steps (gray in color) from the main workspace, leaving only the summary outcome of each job run.
  • Hide Successful - hides all successful job steps (green row header) allowing the focus to be failed jobs for easier troubleshooting.

Duration vs. Execution Run Bar Chart

---

Back to Documentation Main

---

Microsoft®, Windows® and SQL Server® are registered trademarks of Microsoft Corporation in the United States and/or other countries.
Some icons courtesy of Icons8