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:
Member Modules:
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>