SQLJobCommander:Documentation: Difference between revisions
From Brentec I.T. Solutions
More actions
| Line 39: | Line 39: | ||
! Context Menu Option !! Description | ! Context Menu Option !! Description | ||
|- | |- | ||
| Create a New Job || | | [[SQLJobCommander:Documentation/JobMonitor/CreateNewJob|Create a New Job]] || | ||
|- | |- | ||
| Start Job at Step || | | Start Job at Step || A dialog will appear showing all job steps, allowing one to choose the job step at which point to start the job. ''This option is disabled should the selected job not contain any steps.'' | ||
|- | |- | ||
| Stop Job || | | Stop Job || Stops the currently selected running job. | ||
|- | |- | ||
| [[SQLJobCommander:Documentation/JobMonitor/ViewHistory|View History]] || Shows the complete execution history for a selected SQL Agent job. | | [[SQLJobCommander:Documentation/JobMonitor/ViewHistory|View History]] || Shows the complete execution history for a selected SQL Agent job in a new window. ''This option is disabled should job history be non-existent for the selected job.'' | ||
|- | |- | ||
| Delete History || | | Delete History || | ||
|- | |- | ||
| Scripting Actions || | | [[SQLJobCommander:Documentation/JobMonitor/ScriptingActions|Scripting Actions]] || | ||
|- | |- | ||
| Copy Job to Another Instance || | | Copy Job to Another Instance || | ||
|- | |- | ||
| Enable || | | Enable || Enables the selected job. ''This option is disabled if the current selected job is already enabled.'' | ||
|- | |- | ||
| Disable || | | Disable || Disables the selected job. ''This option is disabled if the current selected job is already disabled.'' | ||
|- | |- | ||
| Rename || | | Rename || | ||
| Line 61: | Line 61: | ||
| Delete || | | Delete || | ||
|- | |- | ||
| Properties || | | [[SQLJobCommander:Documentation/JobMonitor/Properties|Properties]] || | ||
|} | |} | ||
==== Session Log ==== | ==== Session Log ==== | ||
Revision as of 14:14, 1 April 2026
Introduction
What is SQL Job Commander?
SQL Job Commander is a powerful SQL Server® Agent job management tool that delivers familiar SSMS functionality while adding unique capabilities for enhanced job manipulation and control.
Here are the key features of SQL Job Commander:
- Purpose-built for SQL Server® Agent job management over the traditional SQL Server® Management Studio (SSMS).
- Intuitive, feature-rich environment including the ability to copy jobs between instances and scripting multiple jobs concurrently.
- All-in-one interface for managing multiple SQL Server® Agent instances.
- Per-instance metrics showing succeeded, failed, cancelled, and actively running jobs along with the instance job success rate.
- Clear, per-job running indicator with threshold breach visualization.
- Per-job coloring indicative of job type.
- Per-instance job filtering for those larger estates, finding a job or group of jobs quickly.
- Full job history showing executions by status and the most recent 100 executions by duration visualizations.
- Script output with full T-SQL syntax highlighting.
Requirements
Download & Installation
- Link to download pages, both here and Microsoft Store...
- Installation instructions for local version, Microsoft Store will have its own installer.
Licensing
Release Notes/Changelog
Roadmap
Getting Started
Quick Tour
About
Main Window
Connecting to a SQL Server® Instance
Job Monitor
| Context Menu Option | Description |
|---|---|
| Create a New Job | |
| Start Job at Step | A dialog will appear showing all job steps, allowing one to choose the job step at which point to start the job. This option is disabled should the selected job not contain any steps. |
| Stop Job | Stops the currently selected running job. |
| View History | Shows the complete execution history for a selected SQL Agent job in a new window. This option is disabled should job history be non-existent for the selected job. |
| Delete History | |
| Scripting Actions | |
| Copy Job to Another Instance | |
| Enable | Enables the selected job. This option is disabled if the current selected job is already enabled. |
| Disable | Disables the selected job. This option is disabled if the current selected job is already disabled. |
| Rename | |
| Delete | |
| Properties |