Start SQL Agent Service on Cluster

Microsoft.SQLServer.2012.StartClusteredSQLAgent (Task)

Start SQL Agent Service on Cluster.
Note that all SQL Express editions do not support clustering.

Element properties:

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

Member Modules:

ID	Module Type	TypeId	RunAs
WA	WriteAction	System.CommandExecuter	Default

Source Code:

<Task ID="Microsoft.SQLServer.2012.StartClusteredSQLAgent" Target="SQL2012Core!Microsoft.SQLServer.2012.Agent" Accessibility="Internal" Enabled="true" Remotable="false">

  <Category>Maintenance</Category>

  <WriteAction ID="WA" TypeID="System!System.CommandExecuter">

    <ApplicationName>%windir%\system32\cluster.exe</ApplicationName>

    <WorkingDirectory>%windir%\system32</WorkingDirectory>

    <CommandLine>/cluster:$Target/Host/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$ resource "$Target/Host/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/AgentClusterName$" /online</CommandLine>

    <TimeoutSeconds>300</TimeoutSeconds>

    <RequireOutput>true</RequireOutput>

    <Files/>

  </WriteAction>

</Task>