SQL Server Agent (Agent XPs disabled)

When SQL Server 2005 Management Studio's Object Browser shows the SQL Server Agent service with a red down arrow and the text Agent XP's disabled, the service is not started or disabled.

Start the SQL Server Agent service by:

• using the SQL Server Configuration Manger
  located in Start -> Microsoft SQL Server 2005 -> Configuration Tools -> SQL Server Configuration Manager
• Or use the Services Management Console
  located in Start -> Control Panel -> Administrative Tools -> Services
• Or you can start the default service from the command prompt
  net start "SQL Server Agent (instance name)"
  Eg: net start "SQL Server Agent (MSSQLSERVER)"