Démarrer le service SQL Agent

Microsoft.SQLServer.2008.StartSQLAgentFromJob (Task)

Démarrer le service SQL Agent.
Notez que le service Windows SQL Server Agent n'est pris en charge par aucune édition de SQL Server Express.

Element properties:

Target	Microsoft.SQLServer.2008.AgentJob
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.2008.StartSQLAgentFromJob" Target="SQL2008Core!Microsoft.SQLServer.2008.AgentJob" Accessibility="Internal" Enabled="true" Remotable="false">

  <Category>Maintenance</Category>

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

    <ApplicationName/>

    <WorkingDirectory/>

    <CommandLine>net start $Target/Host/Property[Type="SQL!Microsoft.SQLServer.Agent"]/ServiceName$</CommandLine>

    <TimeoutSeconds>300</TimeoutSeconds>

    <RequireOutput>true</RequireOutput>

    <Files/>

  </WriteAction>

</Task>