Iniciar Serviço SQL Agent no Mecanismo de Banco de Dados
Microsoft.SQLServer.2016.StartSQLAgentFromDBEngineInstance (Task)
Inicie o Serviço SQL Agent no mecanismo de banco de dados.
Observe que nenhuma edição do SQL Server Express dá suporte ao Serviço Windows do SQL Server Agent.
Element properties: Member Modules:
Source Code: <Task ID="Microsoft.SQLServer.2016.StartSQLAgentFromDBEngineInstance" Target="SQL2016Core!Microsoft.SQLServer.2016.DBEngine" Accessibility="Internal" Enabled="true" Remotable="false">
<Category>Maintenance</Category>
<WriteAction ID="WA" TypeID="System!System.CommandExecuter" RunAs="GPMP!Microsoft.SQLServer.TaskAccount">
<ApplicationName/>
<WorkingDirectory/>
<CommandLine>net start $Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/AgentName$</CommandLine>
<TimeoutSeconds>300</TimeoutSeconds>
<RequireOutput>true</RequireOutput>
<Files/>
</WriteAction>
</Task>