Iniciar el servicio Agente SQL

Microsoft.SQLServer.Windows.Task.LocalAgent.StartService (Task)

Inicie el servicio Agente SQL
Tenga en cuenta que el servicio de Windows del Agente SQL Server no se admite en ninguna edición de SQL Server Express.

Element properties:

Member Modules:

Source Code:

<Task ID="Microsoft.SQLServer.Windows.Task.LocalAgent.StartService" Target="SqlDiscW!Microsoft.SQLServer.Windows.LocalAgent" 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/Property[Type="SqlDiscW!Microsoft.SQLServer.Windows.Agent"]/ComputerName$</ComputerName>

    <ServiceName>$Target/Property[Type="SqlDiscW!Microsoft.SQLServer.Windows.Agent"]/ServiceName$</ServiceName>

    <ServiceCommand>Start</ServiceCommand>

    <InstanceVersion>$Target/Host/Property[Type="SqlCoreLib!Microsoft.SQLServer.Core.DBEngine"]/Version$</InstanceVersion>

    <TimeoutSeconds>300</TimeoutSeconds>

    <Publisher>SQLMonitoringWindows</Publisher>

    <ManagementGroupName>$Target/ManagementGroup/Name$</ManagementGroupName>

  </WriteAction>

</Task>