SQLJobCommander:Documentation

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.

Download & Installation

Overview

SQL Job Commander is a desktop application for managing and executing SQL Server Agent jobs. It is available in two distribution packages: a standard (framework-dependent) build and a self-contained build.

System Requirements

Requirement	Standard Build	Self-Contained Build
.NET 8 Desktop Runtime	Required	Not required (bundled)
Operating System	Windows	Windows

• System requirements for SQL Job Commander

Download Packages

Standard Build (Framework-Dependent)

Note: Requires the .NET 8 Desktop Runtime to be installed on the client machine.

Field	Value
Filename	sjc-0.1.2606.0.zip
SHA256 Hash	1eaf980d5bbd20bf144878a0e5dc3eab5789f23229d32c8eb6b454ebcac31416
Features Expiry	January 1, 2027
Download	Download SQL Job Commander
Virus Scan	Verify on VirusTotal

Self-Contained Build

Note: The .NET 8 Desktop Runtime is not required. The runtime is bundled within the executable.

Field	Value
Filename	sjc-0.1.2606.0-sc.zip
SHA256 Hash	a99ca21b3a633eea465d882062df07a64bafa0df53a096d2729a30d23f7373c4
Features Expiry	January 1, 2027
Download	Download SQL Job Commander (Self-Contained)
Virus Scan	Verify on VirusTotal

Installation

1. Download the appropriate .zip file for your environment (see above).
2. Verify the file integrity using the SHA256 hash provided (see Verifying the Download below).
3. Extract the contents of the .zip file to a folder of your choice.
4. If using the standard build, ensure the .NET 8 Desktop Runtime is installed before launching.
5. Run SQLJobCommander.exe from the extracted folder.

Verifying the Download

To confirm your download has not been tampered with, verify the SHA256 hash of the .zip file before extracting it.

Using PowerShell (Windows):

Get-FileHash .\sjc-0.1.2606.0.zip -Algorithm SHA256

Compare the output against the SHA256 hash listed in the download table above. Alternatively, you can submit the hash directly to VirusTotal using the links provided.

Feature Expiry Notice

Warning: Features Expiry Date: January 1, 2027 After this date, some features of SQL Job Commander will cease to function. However, the core execution functionality will continue to work beyond the expiry date. It is recommended to check the downloads page for an updated version before this date.

Which Build Should I Choose?

Scenario	Recommended Build
.NET 8 Desktop Runtime is already installed	Standard Build (smaller download)
Deploying to a machine without internet access or where installing runtimes is restricted	Self-Contained Build
Unsure	Self-Contained Build

Release Notes/Changelog

• Release notes for SQL Job Commander

Roadmap

• Future plans for SQL Job Commander

Getting Started

Quick Tour

Job Monitor

The Job Monitor component serves as a comprehensive at-a-glance view of all SQL Agent jobs for each connected SQL Server® instance within SQL Job Commander.

Much like SQL Server® Management Studio's Job Activity Monitor, it displays a grid of every job on the connected instance, surfacing key details such as job name, enabled status, current execution status (running, idle, cancelled, or failed), last run outcome, last run date and time, next scheduled run, and the executing step — all in one unified panel. Users can quickly identify stuck, failed, or long-running jobs without needing to query system tables manually, and can take immediate action by right-clicking a job for further actions directly from the grid.

Each Job Monitor supports sorting and filtering, allowing operators to zero in on jobs matching specific criteria — such as all currently running jobs or all jobs that failed within the last cycle. Designed for both at-a-glance monitoring and rapid triage, the Job Monitor transforms what would otherwise be a fragmented, query-heavy workflow into a streamlined, visual operations hub that keeps database administrators firmly in control of their job pipeline.

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 the operator 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