SMS_SCI_SQLCmd Server WMI Class

 

Updated: November 1, 2013

Applies To: System Center 2012 Configuration Manager, System Center 2012 Configuration Manager SP1, System Center 2012 R2 Configuration Manager

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

The SMS_SCI_SQLCmd class does not define any methods.

BeginTime

Data type: DateTime

Access type: Read/Write

Qualifiers: None

Beginning 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: UInt32

Access type: Read/Write

Qualifiers: [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: 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 "00000000115900.000000+***". Only the hours and minutes of this property are used.

LogFile

Data type: String

Access type: Read/Write

Qualifiers: None

Log file to which to write the output. The default value is "".

Name

Data type: String

Access type: Read/Write

Qualifiers: None

User-defined name given to the SQL command. The default value is "".

NumRefreshDays

Data type: UInt32

Access type: Read/Write

Qualifiers: None

Number of days between SQL task executions. The default value is 0.

On

Data type: Boolean

Access type: Read/Write

Qualifiers: None

true (default) if the SQL command is activated.

SiteCode

Data type: String

Access type: Read/Write

Qualifiers: [key, SizeLimit("3")]

See SMS_SiteControlItem Server WMI Class.

SQLCmd

Data type: String

Access type: Read/Write

Qualifiers: None

SQL command to execute. The default value is "".

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.

Show: