Arrêter le service SQL Agent

Microsoft.SQLServer.2016.StopSQLAgent (Task)

Arrêter le service SQL Agent
Le service Windows de SQL Server Agent n’est pris en charge par aucune édition de SQL Server Express.

Element properties:

Target	Microsoft.SQLServer.2016.Agent
Accessibility	Internal
Category	Maintenance
Enabled	True
Remotable	False
Timeout	300

Member Modules:

ID	Module Type	TypeId	RunAs
WA	WriteAction	System.CommandExecuter	Microsoft.SQLServer.TaskAccount

Source Code:

<Task ID="Microsoft.SQLServer.2016.StopSQLAgent" Target="SQL2016Core!Microsoft.SQLServer.2016.Agent" Accessibility="Internal" Enabled="true" Remotable="false">

  <Category>Maintenance</Category>

  <WriteAction ID="WA" TypeID="System!System.CommandExecuter" RunAs="GPMP!Microsoft.SQLServer.TaskAccount">

    <ApplicationName/>

    <WorkingDirectory/>

    <CommandLine>net stop $Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.Agent"]/ServiceName$</CommandLine>

    <TimeoutSeconds>300</TimeoutSeconds>

    <RequireOutput>true</RequireOutput>

    <Files/>

  </WriteAction>

</Task>