Is it possible to automatically start the agent when sql server starts?
When you boot the server than both windows services get started.
But when you stop the main sql server service agent also gets stopped. The problem is that the reverse is not true. When you start the main sql server windows service again than agent wont be started automatically. This tends to be forgotten a lot here.
Is there a way to start agent as a consequence of starting sql server?