Starting and stopping the SQL Server Agent

When you shut down the SQL Server Agent while monitoring of the SQL Server Agent is turned on, the SQLAgentStatus parameter goes into an alarm state.

You can shut down the SQL Server Agent from PATROL by using the SQL Server Admin > Shutdown SQL Server Agent menu command from the Server application pop-up menu.

Warning

Some Microsoft SQL Server features, such as Replication, cannot operate unless the SQL Server Agent is running.


You can restart the SQL Server Agent that you previously shut down by using the SQL Server Admin > Start SQL Server Agent menu command from the Server application pop-up menu. The Start SQL Server Agent menu command forces the SQL Server to start if it is not already running, and then it starts the SQL Server Agent.

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*