User OpName varchar The name of the operation (usually, as passed into Minion.CheckDBMaster). Valid values: CHECKTABLE CHECKDB AUTO NumConcurrentProcesses tinyint The number of concurrent processes used. This is the number of databases that will be processed simultaneously (CheckDB or CheckTable). DBInternalThreads tinyint If CheckTable, this is the number of tables that will be processed in parallel. NumDBsOnServer int Number of databases on server. NumDBsProcessed int Number of databases processed in this operation. RotationLimiter varchar The method that was used to limit the rotation (DBCount, TableCount, or Time). RotationLimiterMetric varchar The metric by which the RotationLimiter was defined (count, or minutes). RotationMetricValue int The number associated with the RotationLimiter, e.g., 10 for 10 databases, or 120 for 120 Mins. TimeLimitInMins int The time imposed on this opertion, in minutes. ExecutionEndDateTime datetime Date and time the entire operation completed. ExecutionRunTimeInSecs float The duration, in seconds, of the entire operation. BatchPreCodeStartDateTime datetime Start date of the batch precode. BatchPostCodeStartDateTime datetime Start date of the batch postcode. BatchPreCode varchar Precode set to run before the entire operation. This code is set in the Minion.CheckDBSettingsServer table. BatchPostCode varchar Precode set to run after the entire operation. This code is set in the Minion.CheckDBSettingsServer table. Schemas varchar The schema or schemas that were passed to the operation. Schemas = NULL means the maintenance was not limited by schema. See the @Schema entry for Minion.CheckDBMaster for more information. Tables varchar The table or tables that were passed into the operation.
User OpName varchar The name of the operation (usually, as passed into Minion.CheckDBMaster). Valid values: CHECKTABLE CHECKDB AUTO NumConcurrentProcesses tinyint The number of concurrent processes used. This is the number of databases that will be processed simultaneously (CheckDB or CheckTable). DBInternalThreads tinyint If CheckTable, this is the number of tables that will be processed in parallel. NumDBsOnServer int Number of databases on server. NumDBsProcessed int Number of databases processed in this operation. RotationLimiter varchar The method that was used to limit the rotation (DBCount, TableCount, or Time). RotationLimiterMetric varchar The metric by which the RotationLimiter was defined (count, or minutes). RotationMetricValue int The number associated with the RotationLimiter, e.g., 10 for 10 databases, or 120 for 120 Mins. TimeLimitInMins int The time imposed on this opertion, in minutes. ExecutionEndDateTime datetime Date and time the entire operation completed. ExecutionRunTimeInSecs float The duration, in seconds, of the entire operation. BatchPreCodeStartDateTime datetime Start date of the batch precode. BatchPostCodeStartDateTime datetime Start date of the batch postcode. BatchPreCode varchar Precode set to run before the entire operation. This code is set in the Minion.CheckDBSettingsServer table. BatchPostCode varchar Precode set to run after the entire operation. This code is set in the Minion.CheckDBSettingsServer table. Schemas varchar The schema or schemas that were passed to the operation. Schemas = NULL means the maintenance was not limited by schema. See the @Schema entry for Minion.CheckDBMaster for more information. Tables varchar The table or tables that were passed into the operation.