Visually browse, create, edit and control SQL Server Agent jobs directly from VS Code — an SSMS Object Explorer / Job Properties alternative that never leaves the editor.
Getting started
- Click the SQL Agent Jobs icon in the Activity Bar (left-hand sidebar).
- Click Connect to Server, choose an authentication method, and enter your server name and credentials.
- Browse jobs in the sidebar tree — click any job to open its full detail.
Your password is stored via VS Code's secure SecretStorage, never written to settings.json.
Authentication
- SQL Server Authentication — a SQL login and password.
- Windows Authentication (NTLM) — domain\user and password. This only works if the target domain accepts NTLM; some hardened Active Directory environments disable it in favor of Kerberos-only, in which case SQL Server Authentication is the way to connect.
- Windows SSO (Kerberos/SSPI, no password) — not currently
available in this build. It requires a native driver that must be
compiled for your exact VS Code/Electron version; see
docs/windows-sso-setup.mdin the repository if you want to enable it yourself.
Features
- Job list with color-coded status (enabled/disabled, last run outcome)
- Job detail in SSMS-style tabs: General, Steps, Schedules, Alerts, Notifications, Targets, History — click a step to expand its full detail (type, database, on-success/on-failure action, retry settings, full command)
- Start Now, Enable/Disable, Delete — from the tree or from the detail view
- New Job — name, description, one or more steps that can be reordered and removed, three step types (T-SQL, Operating system (CmdExec), PowerShell), full on success / on failure actions per step (quit success, quit failure, go to next step, or jump to a specific step), a target server (local, or any server already enlisted for multi-server administration), and one or more schedules — daily / weekly (pick weekdays) / monthly (pick day of month), each either running once at a set time or repeating during the day (e.g. every 2 hours between 06:00 and 22:00)
- Edit an existing job — updates the core properties and fully replaces the steps
- Notifications — e-mail / page / Windows event log with operator selection and a condition (on failure / success / completion), plus "automatically delete job" (write-only — the current setting can't be read back, so it always starts unchecked)
Known limitations
- Jobs run on a single target server per job — full multi-server push
to several targets at once (
sp_apply_job_to_targets) isn't supported, only picking which single server (local or an already-enlisted target server) a job runs on. - Step "Advanced" options from SSMS — output file, log to table, run as proxy user — aren't exposed yet (less commonly used; can be added if needed).
- Monthly schedules only support a fixed day-of-month (e.g. "the 15th") — relative recurrence ("the last Friday of the month") isn't in the UI yet.
Development
See CONTRIBUTING.md for running the extension locally and
packaging it into a .vsix.