How Can SQL Server Agent Make Life Easier?

  • Josef Finsel


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.


Enterprise Manager Alert System Maintenance Plan Master Server Domain Account 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Josef Finsel 2001

Authors and Affiliations

  • Josef Finsel

There are no affiliations available

Personalised recommendations