This post has been split into a pillar and three focused posts, each generator script now has its own page with its own real bugs, Example Output, and Related Scripts, rather than three topics crammed into one long post.
Start at the hub: SQL Server Maintenance Job Framework
- Generate Backup Jobs — full backups, log backups, cleanup, and the real CmdExec/forfiles bug found testing it live
- Generate Database Integrity and Housekeeping Jobs — DBCC CHECKDB, msdb history cleanup, error log cycling, and the real EXEC parameter bug found testing it live
- Generate Index Maintenance Jobs — index rebuilds/reorganizes and statistics updates, plus a real memory-pressure finding from testing it live
All three scripts, and the repo links, are covered in full on their own pages above. This page stays up so any existing links keep working.
Leave a Reply