Check Disk (DBCC)

Microsoft.SQLServer.2012.Database.DBCC.CheckAlloc (Task)

Checks the consistency of disk space allocation structures for a specified database.

Element properties:

Target	Microsoft.SQLServer.2012.Database
Accessibility	Internal
Category	Maintenance
Enabled	True
Remotable	False
Timeout	300

Member Modules:

ID	Module Type	TypeId	RunAs
PA	ProbeAction	System.CommandExecuterProbe	Microsoft.SQLServer.SQLDefaultAccount

Source Code:

<Task ID="Microsoft.SQLServer.2012.Database.DBCC.CheckAlloc" Target="SQL2012Core!Microsoft.SQLServer.2012.Database" Accessibility="Internal" Enabled="true">

  <Category>Maintenance</Category>

  <ProbeAction ID="PA" TypeID="System!System.CommandExecuterProbe" RunAs="SQL!Microsoft.SQLServer.SQLDefaultAccount">

    <ApplicationName>$Target/Host/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ToolsPath$\Binn\OSQL.EXE</ApplicationName>

    <WorkingDirectory>$Target/Host/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ToolsPath$\Binn</WorkingDirectory>

    <CommandLine>-S $Target/Host/Property[Type="SQL!Microsoft.SQLServer.DBEngine"]/ConnectionString$ -E -Q "DBCC CHECKALLOC('$Target/Property[Type="SQL!Microsoft.SQLServer.Database"]/DatabaseName$')"</CommandLine>

    <TimeoutSeconds>300</TimeoutSeconds>

    <RequireOutput>true</RequireOutput>

  </ProbeAction>

</Task>