Taming sysjobhistory: Strategies for Managing SQL Server Agent History Growth
SQL Server Agent job history accumulates indefinitely by default. Here is how to measure, control, and purge sysjobhistory before it becomes a production problem.
Read article →
SQL Server 2019 Cumulative Update 2: Bug Fixes and a Warning
SQL Server 2019 CU2 delivers critical bug fixes but ships with a known regression that breaks SQL Server Agent. Here is what DBAs need to know before installing.
Read article →
How to Resolve an Agent XPs Disabled Error
Seeing an Agent XPs disabled error in SQL Server Management Studio? Learn how to enable Agent XPs using sp_configure and get SQL Server Agent running again.
Read article →
How to Resolve the SSIS Subsystem That Failed to Load
After restoring msdb from an old server, SQL Server Agent can no longer find the SSIS subsystem DLL. Here is how to fix it in minutes.
Read article →
How to Find SQL Agent Tasks and Schedules
Query SQL Server Agent jobs and schedules directly from msdb using a single T-SQL script. Identify overlapping jobs, disabled tasks and performance issues fast.
Read article →
How to Fix Very Large MSDB Database
A bloated MSDB database can cause maintenance jobs to fail and monitoring alerts to fire. Learn how to identify the cause and fix it safely.
Read article →