How to check the status of a target server (Enterprise Manager)
To check the status of a target server
- Expand a server group, and then expand a server.
- Expand Management.
- Right-click SQL Server Agent, point to Multi Server Administration, and then click Manage Target Servers.
- On the Target Server Status tab, right-click a server, and then click Check SQLServerAgent State.