Interromper Serviço SQL Agent
Microsoft.SQLServer.Windows.Task.LocalAgentJob.StopSQLAgentFromJob (Task)
Interrompa Serviço SQL Agent
Observe que nenhuma edição do SQL Express dá suporte ao Serviço Windows do SQL Server Agent.
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>