Check Database (DBCC)

Microsoft.SQLServer.Linux.Task.Database.DBCCCheckDB (Task)

Checks the allocation, structural, and logical integrity of all the objects in the specified database.

Element properties:

TargetMicrosoft.SQLServer.Linux.Database
AccessibilityInternal
CategoryMaintenance
EnabledTrue
RemotableFalse
Timeout300

Member Modules:

ID Module Type TypeId RunAs 
WA ProbeAction Microsoft.SQLServer.Linux.ProbeAction.DBCCCommandExecutor Microsoft.SQLServer.Core.RunAs.Task

Source Code:

<Task ID="Microsoft.SQLServer.Linux.Task.Database.DBCCCheckDB" Target="SqlDiscL!Microsoft.SQLServer.Linux.Database" Accessibility="Internal" Enabled="true">
<Category>Maintenance</Category>
<ProbeAction ID="WA" TypeID="Microsoft.SQLServer.Linux.ProbeAction.DBCCCommandExecutor" RunAs="SqlCoreLib!Microsoft.SQLServer.Core.RunAs.Task">
<MachineName>$Target/Host/Property[Type="SqlCoreLib!Microsoft.SQLServer.Core.DBEngine"]/MachineName$</MachineName>
<NetbiosComputerName>$Target/Host/Property[Type="SqlCoreLib!Microsoft.SQLServer.Core.DBEngine"]/NetbiosComputerName$</NetbiosComputerName>
<InstanceName>$Target/Host/Property[Type="SqlCoreLib!Microsoft.SQLServer.Core.DBEngine"]/InstanceName$</InstanceName>
<ConnectionString>$Target/Host/Property[Type="SqlCoreLib!Microsoft.SQLServer.Core.DBEngine"]/ConnectionString$</ConnectionString>
<InstanceVersion>$Target/Host/Property[Type="SqlCoreLib!Microsoft.SQLServer.Core.DBEngine"]/Version$</InstanceVersion>
<InstanceEdition>$Target/Host/Property[Type="SqlCoreLib!Microsoft.SQLServer.Core.DBEngine"]/Edition$</InstanceEdition>
<Login>$RunAs[Name="SqlCoreLib!Microsoft.SQLServer.Core.RunAs.SqlCredentials"]/UserName$</Login>
<Password>$RunAs[Name="SqlCoreLib!Microsoft.SQLServer.Core.RunAs.SqlCredentials"]/Password$</Password>
<CommandName>CHECKDB</CommandName>
<DatabaseName>$Target/Property[Type="SqlCoreLib!Microsoft.SQLServer.Core.Database"]/DatabaseName$</DatabaseName>
<SqlExecTimeoutSeconds>60</SqlExecTimeoutSeconds>
<SqlTimeoutSeconds>15</SqlTimeoutSeconds>
<TimeoutSeconds>300</TimeoutSeconds>
<Publisher>SQLMonitoringLinux</Publisher>
<ManagementGroupName>$Target/ManagementGroup/Name$</ManagementGroupName>
</ProbeAction>
</Task>