The SMS_SCI_SQLCmd Windows Management Instrumentation (WMI) class is an SMS Provider server class, in Configuration Manager, that defines a Structured Query Language (SQL) command to be run periodically directly in the SQL Server database.
The following syntax is simplified from Managed Object Format (MOF) code and includes all inherited properties.
Class SMS_SCI_SQLCmd : SMS_SiteControlItem
{
DateTime BeginTime;
UInt32 DaysOfWeek;
UInt32 FileType;
String ItemName;
String ItemType;
DateTime LatestBeginTime;
String LogFile;
String Name;
UInt32 NumRefreshDays;
Boolean On;
String SiteCode;
String SQLCmd;
};
|
Methods
The SMS_SCI_SQLCmd class does not define any methods.
Properties
- BeginTime
- Data type: DateTimeAccess type: Read/WriteQualifiers: NoneBeginning time for execution of the SQL command. 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 command executes. Possible
values are listed below.
0
SUNDAY
1
MONDAY
2
TUESDAY
3
WEDNESDAY
4
THURSDAY
5
FRIDAY
6
SATURDAY
- 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 "00000000115900.000000+***". Only the hours and minutes of this property are used.
- LogFile
- Data type: StringAccess type: Read/WriteQualifiers: NoneLog file to which to write the output. The default value is "".
- Name
- Data type: StringAccess type: Read/WriteQualifiers: NoneUser-defined name given to the SQL command. The default value is "".
- NumRefreshDays
- Data type: UInt32Access type: Read/WriteQualifiers: NoneNumber of days between SQL task executions. The default value is 0.
- On
- Data type: BooleanAccess type: Read/WriteQualifiers: Nonetrue (default) if the SQL command is activated.
- SiteCode
- Data type: StringAccess type: Read/WriteQualifiers: [key, SizeLimit("3")]See SMS_SiteControlItem Server WMI Class.
- SQLCmd
- Data type: StringAccess type: Read/WriteQualifiers: NoneSQL command to execute. The default value is "".
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.