SQL Server Agent Service (Set Startup Type) The screenshot shows how to set the SQL Server Agent service startup type to “Automatic” for automatic startup.