Stop SQL Agent Service
Microsoft.SQLServer.Windows.Task.LocalAgentJob.StopSQLAgentFromJob (Task)
Stop SQL Agent Service
Note that SQL Server Agent Windows Service is not supported by any edition of SQL Server Express.
Element properties:
Member Modules:
Source Code:
<Task ID="Microsoft.SQLServer.Windows.Task.LocalAgentJob.StopSQLAgentFromJob" Target="SqlDiscW!Microsoft.SQLServer.Windows.LocalAgentJob" Accessibility="Internal" Enabled="true" Remotable="false">
<Category>Maintenance</Category>
<WriteAction ID="WA" TypeID="Microsoft.SQLServer.Windows.WriteAction.ServiceControl" RunAs="SqlCoreLib!Microsoft.SQLServer.Core.RunAs.Task">
<ComputerName>$Target/Host/Property[Type="SqlDiscW!Microsoft.SQLServer.Windows.Agent"]/ComputerName$</ComputerName>
<ServiceName>$Target/Host/Property[Type="SqlDiscW!Microsoft.SQLServer.Windows.Agent"]/ServiceName$</ServiceName>
<ServiceCommand>Stop</ServiceCommand>
<InstanceVersion>$Target/Host/Host/Property[Type="SqlCoreLib!Microsoft.SQLServer.Core.DBEngine"]/Version$</InstanceVersion>
<TimeoutSeconds>300</TimeoutSeconds>
<Publisher>SQLMonitoringWindows</Publisher>
<ManagementGroupName>$Target/ManagementGroup/Name$</ManagementGroupName>
</WriteAction>
</Task>