I need to Start up the SERVER AGENT after install SSMS

Question

dHi, i need to start the server agent but i got this error trying it with the Configuration Manager: after i was looking at WINDOWS SERVICES and i got this: ANY SOLUTION FOR THAT?? Thanks..

Nirav Gandhi · Answer

HI, Please check @Ramon Quintana answer. it's the correct answer.

Suraj Kumar · Answer

Dear Ramon, I have not any personal issue with accepted answer rather than I want to give attention on the quality of answer to be accepted. It is not only for you as accepted answer is used to help other user find the better solution easily for the related problem. Accepted answer with better solution also improve the quality of communtiy. As I can see the current accepted answer doesn't provide the better and good solution rather than a simple statement or suggestion. So, it should not be accepted. Hope you understodd and it applies to all the communtiy members and it is just my personal view for a community.

Ramon Quintana · Answer

Hi Subbu, After start SQLAgent(SQLEXPRESS02) (NOTE THAT IT IS RUNNING) i try to start SERVER AGENT but it appers DISABLED, try to change this condition but it was not posible due to all options to do that are blocked.

Ramon Quintana · Answer

I think i due to I installed SSMS free and that versión is without Server Agent, i´m look to find out another way to calls SQL files from Windows like Task Schedule and excute a .bat file from it, but i was trying to excute the .sql file from CMD but i got this message: C:\BPC\Procesos_Almacenados>sql.bat C:\BPC\Procesos_Almacenados>echo off Changed database context to '1RQ_BPCSQL1'. Presione una tecla para salir...: could you know why of that? Thanks

Subbarao A · Answer

Hi , Can you check below link https://support.microsoft.com/en-gb/help/955763/the-sql-server-agent-service-does-not-start-after-you-upgrade-from-sql

Subbarao A · Answer

Hi Please start SQL server service first then start server agent