Auto-start the SQL Server Agent after a computer restart

I am using the SQL Server Agent to run some jobs every day, but the problem is that whenever the server (the machine itself) is restarted, the SQL Server Agent doesn't automatically start when the computer boots back up again...and I have to start it manually myself.

How can I set the Server Agent to Auto-Start after a computer restart?
Is there a particular Windows Service I need to set as auto-start ?

Solution 1:

Run services.msc, go to SQL SERVER AGENT service and set it on automatic start-up type

You can do the same thing by accessing sql server configuration manager that should be located in start/programs/microsoft sql server/configuration tools.

Solution 2:

1. Check/ reset the user account that SQL Server Agent is using through SQL Server Configuration Manager (don't use services.msc) This will ensure correct permissions on files.
2. Check the Windows event log for any errors
3. Check the SQLAGENT.OUT file for any errors
4. Open SSMS and ensure that your MSDB database is there & functional

Solution 3:

1. Run Program: SQL Server Configuration Manager
2. click on SQL Server Services.
3. Right Click on SQL Server Agent and click on Properties.
4. click on Service tab and set Start Mode = Automatic.