How Can SQL Server Agent Make Life Easier?
SQL Server Agent isn’t a secret agent like Maxwell Smart from “Get Smart.” Then again, who is? Rather, SQL Server Agent will help you manage some of the chaos that surrounds the day-to-day operation of SQL Server so you’ll have more C.O.N.T.R.O.L. (sorry, couldn’t resist). Using SQL Server Agent you can schedule jobs (repetitive task, processes, and so forth) to run in SQL Server, and you can also set it up to notify you of problems when they occur. In fact, you can even set up SQL Server Agent to respond to an error or warning so that it not only notifies you but takes action as well. In this chapter we’re going to introduce you to SQL Server Agent, explain its scheduling capability, and explain how it can respond to errors.
KeywordsEnterprise Manager Alert System Maintenance Plan Master Server Domain Account
Unable to display preview. Download preview PDF.