Missed the live session? Watch the full recording now.
Why You Shouldn’t Use SQL Agent for Batch Processes
Brent Ozar
SQL Server Performance Expert · Founder, Brent Ozar Unlimited®
Read more
SQL Server Agent handles database-local tasks like backups, corruption checks, and statistics maintenance well. But as batch processes grow more complex, they need things Agent wasn’t built for: cross-system orchestration, real observability, HA-aware recovery, source-controlled deployments, replayability, security boundaries, and cloud portability. Teams end up patching the gaps with scripts and workarounds instead.
In this session, Brent Ozar traces where that ceiling shows up and what signs to watch for as your own batch processes approach it.
Agenda includes:
• Where Agent fits well: backups, corruption checks, statistics maintenance
• Why Agent’s scope stops short of general batch processing
• Capabilities complex batch processes need that Agent lacks
• Common workarounds, and why they add fragility
• Signs your batch processes have outgrown Agent
• What to look for in the next layer of the stack
• Live demo: JAMS Scheduler addressing that ceiling
• Live Q&A
How to Measure Your SQL Server
Curious how your SQL Server actually stacks up? Brent walks through the metrics that matter when you’re sizing up server performance and what they tell you about the health of your environment.
Your SQL Server Toolkit Just Got Bigger
Now that you know how to measure your SQL Server's health, put that knowledge to work. Here are two free tools to help you go further.
Windows Task Scheduler Diagnostics Script
Instantly audit your Windows Task Scheduler jobs and catch problems before they catch you.
JUMP Migration Tool for SQL Agent
Migrate off SQL Agent fast—no manual rework, no headaches.
