This discovery rule discovers the SQL Server Agent for an instance of SQL Server 2014 DB Engine. There could be only one SQL Server Agent instance for each DB Engine instance.
This discovery rule discovers the SQL Server Agent for an instance of SQL Server 2014 DB Engine. There could be only one SQL Server Agent instance for each DB Engine instance.
Name | Description | Default Value |
Enabled | Enables or disables the workflow. | Yes |
Frequency (seconds) | The recurring interval of time in seconds in which to run the workflow. | 14400 |
Target | Microsoft.SQLServer.2014.DBEngine |
Enabled | True |
Frequency | 14400 |
Remotable | False |
Discovered Classes and their attribuets: |
---|
|
ID | Module Type | TypeId | RunAs |
---|---|---|---|
DS | DataSource | Microsoft.Windows.WmiProviderWithClassSnapshotDataMapper | Microsoft.SQLServer.2014.SQLDiscoveryAccount |
<Discovery ID="Microsoft.SQLServer.2014.AgentDiscovery" Target="Microsoft.SQLServer.2014.DBEngine" Enabled="true">
<Category>Discovery</Category>
<DiscoveryTypes>
<DiscoveryClass TypeID="Microsoft.SQLServer.2014.Agent">
<Property TypeID="Microsoft.SQLServer.2014.Agent" PropertyID="ServiceName"/>
<Property TypeID="Microsoft.SQLServer.2014.Agent" PropertyID="Account"/>
<Property TypeID="Microsoft.SQLServer.2014.Agent" PropertyID="DisplayName"/>
</DiscoveryClass>
</DiscoveryTypes>
<DataSource ID="DS" TypeID="Windows!Microsoft.Windows.WmiProviderWithClassSnapshotDataMapper" RunAs="Microsoft.SQLServer.2014.SQLDiscoveryAccount">
<NameSpace>\\$Target/Host/Property[Type="Windows!Microsoft.Windows.Computer"]/NetworkName$\root\Microsoft\SqlServer\ComputerManagement12</NameSpace>
<Query>SELECT ServiceName, StartName, DisplayName FROM SqlService WHERE ServiceName="$Target/Property[Type="Microsoft.SQLServer.2014.DBEngine"]/AgentName$"</Query>
<Frequency>14400</Frequency>
<ClassId>$MPElement[Name="Microsoft.SQLServer.2014.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="Microsoft.SQLServer.2014.ServerRole"]/InstanceName$</Name>
<Value>$Target/Property[Type="Microsoft.SQLServer.2014.ServerRole"]/InstanceName$</Value>
</Setting>
<Setting>
<Name>$MPElement[Name="Microsoft.SQLServer.2014.Agent"]/ServiceName$</Name>
<Value>$Data/Property[@Name='ServiceName']$</Value>
</Setting>
<Setting>
<Name>$MPElement[Name="Microsoft.SQLServer.2014.Agent"]/Account$</Name>
<Value>$Data/Property[@Name='StartName']$</Value>
</Setting>
<Setting>
<Name>$MPElement[Name="Microsoft.SQLServer.2014.Agent"]/DisplayName$</Name>
<Value>$Data/Property[@Name='DisplayName']$</Value>
</Setting>
</Settings>
</InstanceSettings>
</DataSource>
</Discovery>