Udostępnij za pośrednictwem


How to: Stop SQL Server Agent (SQL Server Management Studio)

The SQL Server Agent can be stopped from SQL Server Management Studio.

Note

To ensure an orderly shutdown, pause Microsoft SQL Server and stop SQL Server Agent before stopping an instance of SQL Server. You can stop both by using either SQL Server Configuration Manager or SQL Server Management Studio.

To stop SQL Server Agent

  1. In Object Explorer, expand the server instance you want to manage.

  2. Right-click SQL Server Agent, and then click Stop.

    A red circle on the icon next to SQL Server Agent indicates that SQL Server Agent stopped successfully.

See Also

Tasks

How to: Start SQL Server Agent (SQL Server Management Studio)
How to: Stop SQL Server Agent (SQL Server Configuration Manager)
How to: Stop SQL Server Agent (net Commands)
How to: Configure WMI to Show Server Status in SQL Server Tools

Concepts

Stopping Services

Help and Information

Getting SQL Server 2005 Assistance