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.
Requirements
- Link to requirements page...
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
- Link to release notes page...
- Release notes per version to include a Known Issues section...
Roadmap
- Link to roadmap page...
- To include - Preferences Panel, Dashboard, etc., ...
Getting Started
Quick Tour
About
Main Window
Connecting to a SQL Server® Instance
Job Monitor
Session Log
Features
Job Monitor
Filters
Auto Refresh
Individual Job Context Menu
Please note that not all options will be available for every job...
Right-clicking on any job within the Job Monitor will show a context menu with the following options.
- Create a New Job...
- Start Job at Step...
- Stop Job
- View History...
- Delete History
- Scripting Actions...
- Copy Job to Another Instance...
- Enable
- Disable
- Rename
- Delete...
- Properties...