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;
};

Methods

The SMS_SCI_SQLTask class does not define any methods.

Properties

BeginTime


Data type: DateTimeAccess type: Read/WriteQualifiers: NoneBeginning 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: UInt32Access type: Read/WriteQualifiers: [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: UInt32Access type: Read/WriteQualifiers: NoneNumber of days after which records are deleted if the TaskType property is set to DELETE. The default value is 0.
DeviceName


Data type: StringAccess type: Read/WriteQualifiers: NoneDevice name if the TaskType property is set to BACKUP. The default value is "".
FileType


Data type: UInt32Access type: Read/WriteQualifiers: [key, enumeration:ToSubClass]See SMS_SiteControlItem Server WMI Class.
ItemName


Data type: StringAccess type: Read-onlyQualifiers: [key, read]See SMS_SiteControlItem Server WMI Class.
ItemType


Data type: StringAccess type: Read-onlyQualifiers: [key, read]See SMS_SiteControlItem Server WMI Class.
LatestBeginTime


Data type: DateTimeAccess type: Read/WriteQualifiers: NoneLatest 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: UInt32Access type: Read/WriteQualifiers: NoneNumber of days between task executions. The default value is 0.
On


Data type: BooleanAccess type: Read/WriteQualifiers: NoneTRUE if the task is active.
SiteCode


Data type: StringAccess type: Read/WriteQualifiers: [key, SizeLimit("3")]See SMS_SiteControlItem Server WMI Class.
TaskName


Data type: StringAccess type: Read/WriteQualifiers: [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: UInt32Access type: Read/WriteQualifiers: NoneTask type. Possible values are listed below. The default value is 0.

1

BACKUP

2

PERIOD

3

DELETE

Remarks

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.

Requirements

Runtime Requirements

For more information, see Configuration Manager Server Runtime Requirements.

Development Requirements

For more information, see Configuration Manager Server Development Requirements.

See Also

Send comments about this topic to Microsoft.