Go to Start, Programs, Microsoft SQL Server 2005, Configuration Tools, SQL Server Configuration Manager and select SQL Server 2005 Services. Right click over SQL Agent and select Properties. On the Service tab click on Start Mode - you'll then be able to use the drop down menu to select Automatic startup. You'll need to make sure that the account running the Agent Service has Log on as Service rights too.
"Hang on lads, I've got a great idea. "
Michael Caine (Charlie Croker) The Italian Job