SQL Server Agent - The Life Preserver for the Drowning DBA

Dive into a comprehensive 57-minute conference talk from the PASS Data Community Summit on leveraging SQL Server Agent for efficient database administration. Learn how to set up and utilize this powerful tool to automate routine tasks, create jobs and alerts, and effectively monitor your database environment. Explore the setup process, job creation, alert configuration, and monitoring techniques. Gain insights into common pitfalls to avoid when working with SQL Server Agent. Discover how to streamline your DBA workflow, from handling on-demand tasks to scheduling regular maintenance. Cover topics such as operators, notifications, job history, performance alerts, and deadlock management. Equip yourself with the knowledge to transform SQL Server Agent into your indispensable ally for maintaining a well-organized and efficient database ecosystem.

Introduction
Why you might be drowning
Operators
OnDemand Tasks
Jobs
Schedules
Notifications
Notification
Job History
Job Fail Details
Common Issues
Alerts
New Alert
Specific Alert
Performance Alerts
Objects
Transactions
Delay Between Response
Deadlock
Alert History
Links
Job Properties