Welcome to Lesson 10 of the SQL Server 2000 Tutorial. In this lesson we will cover the SQL Server Agent. I hope you enjoy the lesson.

SQL Server Agent

SQL Server Agent is the services that automates many of the daily tasks of a DBA.  It basically fires off predefined jobs at scheduled intervals.  Most DBAs use SQL Server Agent to automate backup jobs and send emails.

You can start SQL Server Agent with the SQL Server Service Manager.  Use the services drop down to select SQL Server Agent and click on the start/continue button.