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
| Context Menu Option | Description |
|---|---|
| Create a New Job | |
| Start Job at Step | |
| Stop Job | |
| 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. |
| Delete History | |
| Scripting Actions | |
| Copy Job to Another Instance | |
| Enable | |
| Disable | |
| Rename | |
| Delete | |
| Properties |