SQL 에이전트 서비스 시작

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

SQL 에이전트 서비스 시작
SQL Server 에이전트 Windows 서비스는 모든 버전의 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>