O'Reilly logo

Microsoft® SQL Server® 2008 Step by Step by Mike Hotek

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required