Why is SQL Server Agent not starting?

Question

I just installed my SQL Server 2014 on the top of Windows Server 2012. But after installation SQL Agent is not starting. Can someone tell me like what can I do to solve this? PFA screenshot for the same.

Answer 1

In case you'are using SQL Server Express, before quiting, I think you should know that SQL Server versions (including Express) offers a system stored procedure named sp_procoption, which allows one to define a user stored procedure name to be executed whenever SQL Server instance is started and lives along your SQL Server service. That user stored procedure can contain your onwn scheduling loop.

exec sp_procoption @ProcName = ['put your procedure name'], @OptionName = 'STARTUP', @OptionValue = [on|off]

For further reading, I would suggest checking Armando Pratos's excellent article and this SQL Server Online Book