Chapter 21. SQL Server Agent
After completing this chapter, you will be able to
Create jobs, job steps, and job workflows
Create maintenance plans
Create and assign operators
Create alerts
Through the first 20 chapters of this book, we have discussed a variety of features that can be used to build powerful and flexible database applications. We have also introduced several management and maintenance topics. Although users will be utilizing applications to interact with SQL Server and the data stored within your databases, administrators need to perform repetitive maintenance tasks to ensure that data is protected and performance is optimized.
Many of the jobs administrators perform occur during periods of low utilization on the system, which also usually ...
Get Microsoft® SQL Server® 2008 Step by Step now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
