Démarrer le service SQL Agent sur le cluster

Microsoft.SQLServer.2008.StartClusteredSQLAgent (Task)

Démarrer le service SQL Agent sur le cluster.
Notez qu'aucune édition de SQL Express ne prend en charge le clustering.

Element properties:

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

Member Modules:

ID	Module Type	TypeId	RunAs
WA	WriteAction	System.CommandExecuter	Microsoft.SQLServer.SQLDefaultAccount

Source Code:

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

  <Category>Maintenance</Category>

  <WriteAction ID="WA" TypeID="System!System.CommandExecuter" RunAs="SQL!Microsoft.SQLServer.SQLDefaultAccount">

    <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>