[BUG] Full installer drops and recreates SQL Agent jobs, destroying any custom settings introduced by DBAs on target server

[MisterZeus]

Component

Installer (CLI)

Performance Monitor Version

1.3.0

SQL Server Version

Microsoft SQL Server 2017 (RTM-CU31-GDR) (KB5068402) - 14.0.3515.1 (X64) Oct 3 2025 17:45:52 Copyright (C) 2017 Microsoft Corporation Developer Edition (64-bit) on Windows 10 Enterprise 10.0 (Build 22631: ) (Hypervisor)

Windows Version

Windows 11

Describe the Bug

If we install the Full version's SQL Agent jobs, then swap the owner to something else, then re-install Full version, the owner changes are lost because the SQL Agent job scripts drop and recreate the SQL Agent jobs.

Ideally we would not destroy settings that Erik's job definitions don't care about, but target database owners do care about.

Steps to Reproduce

install the Full version's SQL Agent jobs,
swap the owner to something else,
then re-install Full version.

The owner changes are lost because the SQL Agent job scripts drop and recreate the SQL Agent jobs.

Ideally we would not destroy settings that Erik's job definitions don't care about, but target database owners do care about.

Expected Behavior

Ideally we would not destroy settings that Erik's job definitions don't care about, but target database owners do care about.

Actual Behavior

install the Full version's SQL Agent jobs,
swap the owner to something else,
then re-install Full version.

The owner changes are lost because the SQL Agent job scripts drop and recreate the SQL Agent jobs.

Error Messages / Log Output

Screenshots

No response

Additional Context

No response

[erikdarlingdata]

Good catch — this is a fair concern for production environments where DBAs customize job ownership or other settings.

Plan: add a --preserve-jobs flag (CLI) and a checkbox in the GUI installer that skips job creation/recreation when the jobs already exist. New jobs (if we ever add any) would still be created, but existing ones won't be touched. This gives DBAs a safe upgrade path that doesn't blow away their customizations.

Will be in the next release.

[erikdarlingdata]

Fixed in PR #326 — added --preserve-jobs CLI flag and GUI checkbox. When set, existing SQL Agent jobs are left untouched during upgrades (owner, schedule, notifications preserved). Missing jobs are still created.