How to autostart SQL Server Agent (Enterprise Manager)

How to Install SQL Server 2000

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.