The Management folder contains subfolders for the SQL Server agent, backup devices, current activity, database maintenance plans, and error logs. Each of these plays a key role in managing your server.
SQL Server Agent
The SQL Agent is the “quarterback” when it comes to maintenance tasks. It handles the automation of SQL Server operations. General tasks such as starting and stopping the agent can be accessed from the right-click pop-up menu, as can configuration through the Properties dialog box. Figure 4.12 displays the Agent Properties dialog box.
Figure 4.12. Configuring the SQL Server Agent.
Subfolders for alerts, operators, ...