Descobrir SQL Server Agent para um Mecanismo de Banco de Dados

Microsoft.SQLServer.2008.AgentDiscovery (Discovery)

Esta descoberta de objeto descobre o SQL Server Agent para uma instância do Mecanismo de Banco de Dados do SQL Server 2008. Sempre haverá uma instância do SQL Server Agent para cada instância do Mecanismo de Banco de Dados.

Knowledge Base article:

Resumo

Parâmetros Substituíveis

Nome	Descrição	Valor Padrão
Habilitado	Habilita ou desabilita o fluxo de trabalho.	Sim
Frequência (segundos)	O intervalo recorrente de tempo em segundos durante o qual executar o fluxo de trabalho.	14.400

Element properties:

Target	Microsoft.SQLServer.2008.DBEngine
Enabled	True
Frequency	14400
Remotable	False

Object Discovery Details:

Discovered Classes and their attribuets:
Microsoft.SQLServer.2008.Agent ServiceName Account DisplayName

Member Modules:

ID	Module Type	TypeId	RunAs
DS	DataSource	Microsoft.Windows.WmiProviderWithClassSnapshotDataMapper	Microsoft.SQLServer.SQLDiscoveryAccount

Source Code:

<Discovery ID="Microsoft.SQLServer.2008.AgentDiscovery" Target="Microsoft.SQLServer.2008.DBEngine" Enabled="true">

  <Category>Discovery</Category>

  <DiscoveryTypes>

    <DiscoveryClass TypeID="Microsoft.SQLServer.2008.Agent">

      <Property TypeID="SQL!Microsoft.SQLServer.Agent" PropertyID="ServiceName"/>

      <Property TypeID="SQL!Microsoft.SQLServer.Agent" PropertyID="Account"/>

      <Property TypeID="SQL!Microsoft.SQLServer.Agent" PropertyID="DisplayName"/>

    </DiscoveryClass>

  </DiscoveryTypes>

  <DataSource ID="DS" TypeID="Windows!Microsoft.Windows.WmiProviderWithClassSnapshotDataMapper" RunAs="SQL!Microsoft.SQLServer.SQLDiscoveryAccount">

    <NameSpace>\\$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$\root\Microsoft\SqlServer\ComputerManagement10</NameSpace>

    <Query>SELECT ServiceName, StartName, DisplayName  FROM SqlService WHERE ServiceName="$Target/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/AgentName$"</Query>

    <Frequency>14400</Frequency>

    <ClassId>$MPElement[Name="Microsoft.SQLServer.2008.Agent"]$</ClassId>

    <InstanceSettings>

      <Settings>

        <Setting>

          <Name>$MPElement[Name="Windows!Microsoft.Windows.Computer"]/PrincipalName$</Name>

          <Value>$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/PrincipalName$</Value>

        </Setting>

        <Setting>

          <Name>$MPElement[Name="SQL!Microsoft.SQLServer.ServerRole"]/InstanceName$</Name>

          <Value>$Target/Property[Type="SQL!Microsoft.SQLServer.ServerRole"]/InstanceName$</Value>

        </Setting>

        <Setting>

          <Name>$MPElement[Name="SQL!Microsoft.SQLServer.Agent"]/ServiceName$</Name>

          <Value>$Data/Property[@Name='ServiceName']$</Value>

        </Setting>

        <Setting>

          <Name>$MPElement[Name="SQL!Microsoft.SQLServer.Agent"]/Account$</Name>

          <Value>$Data/Property[@Name='StartName']$</Value>

        </Setting>

        <Setting>

          <Name>$MPElement[Name="SQL!Microsoft.SQLServer.Agent"]/DisplayName$</Name>

          <Value>$Data/Property[@Name='DisplayName']$</Value>

        </Setting>

      </Settings>

    </InstanceSettings>

  </DataSource>

</Discovery>