Démarrer le service SQL Agent
Microsoft.SQLServer.2014.StartSQLAgentFromJob (Task)
Démarrer le service SQL Agent
Le service Windows de 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.2014.StartSQLAgentFromJob" Target="SQL2014Core!Microsoft.SQLServer.2014.AgentJob" Accessibility="Internal" Enabled="true" Remotable="false">
<Category>Maintenance</Category>
<WriteAction ID="WA" TypeID="System!System.CommandExecuter" RunAs="SQL2014Core!Microsoft.SQLServer.2014.SecureReference.Task">
<ApplicationName/>
<WorkingDirectory/>
<CommandLine>net start $Target/Host/Property[Type="SQL2014Core!Microsoft.SQLServer.2014.Agent"]/ServiceName$</CommandLine>
<TimeoutSeconds>300</TimeoutSeconds>
<RequireOutput>true</RequireOutput>
<Files/>
</WriteAction>
</Task>