SMS_SCI_SQLTask Server WMI Class
Updated: October 28, 2009
Applies To: System Center Configuration Manager 2007, System Center Configuration Manager 2007 R2, System Center Configuration Manager 2007 R3, System Center Configuration Manager 2007 SP1, System Center Configuration Manager 2007 SP2
The SMS_SCI_SQLTask Windows Management Instrumentation (WMI) class is an SMS Provider server class, in Configuration Manager, that defines a Structured Query Language (SQL) task to be run periodically.
The following syntax is simplified from Managed Object Format (MOF) code and includes all inherited properties.
Class SMS_SCI_SQLTask : SMS_SiteControlItem
{
DateTime BeginTime;
UInt32 DaysOfWeek;
UInt32 DeleteOlderThan;
String DeviceName;
UInt32 FileType;
String ItemName;
String ItemType;
DateTime LatestBeginTime;
UInt32 NumRefreshDays;
Boolean On;
String SiteCode;
String TaskName;
UInt32 TaskType;
};
The SMS_SCI_SQLTask class does not define any methods.
- BeginTime
- Data type: DateTime Access type: Read/Write Qualifiers: None Beginning time for execution of the SQL task. The default value is "00000000000000.000000+***". Only the hours and minutes of this property are used.
- DaysOfWeek
-
Data type: UInt32
Access type: Read/Write
Qualifiers: [bits]
Days of the week on which the SQL task executes. Possible values are listed below. The default value is 0.
0
SUNDAY
1
MONDAY
2
TUESDAY
3
WEDNESDAY
4
THURSDAY
5
FRIDAY
6
SATURDAY
- DeleteOlderThan
- Data type: UInt32 Access type: Read/Write Qualifiers: None Number of days after which records are deleted if the TaskType property is set to DELETE. The default value is 0.
- DeviceName
- Data type: String Access type: Read/Write Qualifiers: None Device name if the TaskType property is set to BACKUP. The default value is "".
- FileType
- Data type: UInt32 Access type: Read/Write Qualifiers: [key, enumeration:ToSubClass] See SMS_SiteControlItem Server WMI Class.
- ItemName
- Data type: String Access type: Read-only Qualifiers: [key, read] See SMS_SiteControlItem Server WMI Class.
- ItemType
- Data type: String Access type: Read-only Qualifiers: [key, read] See SMS_SiteControlItem Server WMI Class.
- LatestBeginTime
- Data type: DateTime Access type: Read/Write Qualifiers: None Latest beginning time of execution for the SQL command. The default value is "00000000000000.000000+***". Only the hours and minutes of this property are used.
- NumRefreshDays
- Data type: UInt32 Access type: Read/Write Qualifiers: None Number of days between task executions. The default value is 0.
- On
- Data type: Boolean Access type: Read/Write Qualifiers: None TRUE if the task is active.
- SiteCode
- Data type: String Access type: Read/Write Qualifiers: [key, SizeLimit("3")] See SMS_SiteControlItem Server WMI Class.
- TaskName
-
Data type: String
Access type: Read/Write
Qualifiers: [StringEnumeration]
Configuration Manager-defined task name. Possible values are listed below. The default value is "".
REBUILD_INDEXES
Rebuild Indexes
MONITOR_KEYS_RECREATE_VIEWS
Monitor Keys and Recreate Views
DELETE_AGED_INVENTORY_HISTORY
Delete Aged Inventory History
DELETE_AGED_STATUS_OBJECTS
Delete Aged Status Objects
DELETE_AGED_DISCOVERY_DATA
Delete Aged Discovery Data
DELETE_AGED_COLLECTED_FILES
Delete Aged Collected Files
CLEAR_UNDISCOVERED_CLIENTS
Clear Undiscovered Clients
- TaskType
-
Data type: UInt32
Access type: Read/Write
Qualifiers: None
Task type. Possible values are listed below. The default value is 0.
1
BACKUP
2
PERIOD
3
DELETE
There are no special class qualifiers for this class. For more information about both the class qualifiers and the property qualifiers included in the Properties section, see Configuration Manager Class and Property Qualifiers.
Runtime Requirements
For more information, see Configuration Manager Server Runtime Requirements.
Development Requirements
For more information, see Configuration Manager Server Development Requirements.