How To

How to autostart SQL Server Agent (Enterprise Manager)

To autostart SQL Server Agent

  1. Expand a server group, and then expand a server.

  2. Expand Management, right-click SQL Server Agent, and then click Properties.

  3. Click the Advanced tab, and then select the Auto restart SQL Server Agent if it stops unexpectedly check box.