Iniciar Serviço SQL Agent no Mecanismo de Banco de Dados

Microsoft.SQLServer.2012.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.2012.StartSQLAgentFromDBEngineInstance" Target="SQL2012Core!Microsoft.SQLServer.2012.DBEngine" Accessibility="Internal" Enabled="true" Remotable="false">

  <Category>Maintenance</Category>

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

    <ApplicationName/>

    <WorkingDirectory/>

    <CommandLine>net start $Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/AgentName$</CommandLine>

    <TimeoutSeconds>300</TimeoutSeconds>

    <RequireOutput>true</RequireOutput>

    <Files/>

  </WriteAction>

</Task>