SQLJobCommander:Documentation
From Brentec I.T. Solutions
More actions
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
Right-clicking a job will provide a context menu with the following options:
| 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 | This option is disabled should job history by non-existent for the selected job, or, if the job is multi-server in nature. |
| Scripting Actions | |
| Copy Job to Another Instance | This option is disabled if there are fewer than two (2) instance connections. |
| 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 |