After completing this chapter, you will be able to
Create jobs, job steps, and job workflows
Create maintenance plans
Create and assign operators
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 ...