Chapter 27. SQL Server Agent
After completing this chapter, you will be able to
Understand the components of SQL Server Agent.
View SQL Server Agent Configuration Manager options.
Configure SQL Server Agent properties.
Create operators.
Configure alerts and jobs.
Create proxies.
As discussed in Chapter 22, regularly scheduled tasks must be performed to ensure that disaster recovery, retention policies, index performance, and monitoring goals are maintained. To ensure that all of these tasks are accomplished via a single technology, Microsoft SQL Server includes a Windows service known as SQL Server Agent. SQL Server Agent can execute and schedule tasks or jobs. The scheduled tasks should not be confused with Windows scheduled tasks in Task Scheduler. ...
Get Microsoft® SQL Server® 2012 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.
