Can't start sql server Agent

sql-server sql-server-2008-r2 sql-server-agent
SajjadZare picture SajjadZare · Apr 5, 2013 · Viewed 92.5k times · Source

I want to start the SQL Server Agent (sql server 2008 R2 Enterprise edition), then I did:

  1. Open SQL Server configuration manager.
  2. SQL Server services.
  3. Right click on sql server agent.

but when I right click the start item is disable.

Answer

NetStarter picture NetStarter · Apr 5, 2013

Go to run type services.msc

Right click on the SQL Server Agent (MSSQLSERVER)

Then check in the properties your startup type might be disabled change it to automatic or manual and try again it will enable the start option

Related questions

The Messenger service has not been started - NetSend notifications will not be sent

In my SQL Server agent, I did not set any notifications, then why this error is coming? I run pakg through dtsexec it executes successfully, and also I run a simple job for inserting record it runs successfully, but when …

Read More
Script to kill all connections to a database (More than RESTRICTED_USER ROLLBACK)

I have a development database that re-deploy frequently from a Visual Studio Database project (via a TFS Auto Build). Sometimes when I run my build I get this error: ALTER DATABASE failed because a lock could not be placed on …

Read More
Select SQL Server database size

how can i query my sql server to only get the size of database? I used this : use "MY_DB" exec sp_spaceused I got this : database_name database_size unallocated space My_DB 17899.13 MB 5309.39 MB It returns me several …

Read More