檢查類別目錄 (DBCC)
Microsoft.SQLServer.2016.Database.DBCC.CheckCatalog (Task)
檢查指定資料庫內的目錄一致性。資料庫必須在線上。
Element properties:
Member Modules:
Source Code:
<Task ID="Microsoft.SQLServer.2016.Database.DBCC.CheckCatalog" Target="SQL2016Core!Microsoft.SQLServer.2016.Database" Accessibility="Internal" Enabled="true">
<Category>Maintenance</Category>
<ProbeAction ID="PA" TypeID="System!System.CommandExecuterProbe" RunAs="GPMP!Microsoft.SQLServer.TaskAccount">
<ApplicationName>$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/ToolsPath$\Binn\OSQL.EXE</ApplicationName>
<WorkingDirectory>$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/ToolsPath$\Binn</WorkingDirectory>
<CommandLine>-S "$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/ConnectionString$,$Target/Host/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.DBEngine"]/TcpPort$" -E -Q "DBCC CHECKCATALOG('$Target/Property[Type="SQL2016Core!Microsoft.SQLServer.2016.Database"]/DatabaseName$')"</CommandLine>
<TimeoutSeconds>300</TimeoutSeconds>
<RequireOutput>true</RequireOutput>
</ProbeAction>
</Task>