Share via

SMS_SCI_SQLCmd

  • Article

The SMS_SCI_SQLCmd WMI class defines a Structured Query Language (SQL) command to be run periodically directly in the SQL Server database.

The following syntax is simplified from 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;
};

Properties

  • BeginTime
    Data type: datetime
    Access type: Read/write

    Beginning time of the (SQL) command. Note that only the hours and minutes of this datetime property are used.

  • DaysOfWeek
    Data type: uint32
    Access type: Read/write
    Qualifiers: Bits

    Days of the week on which the command executes. The default is everyday. Bit field flags are:
    SUNDAY (0),
    MONDAY (1),
    TUESDAY (2),
    WEDNESDAY (3),
    THURSDAY (4),
    FRIDAY (5),
    SATURDAY (6)

  • FileType
    Data type: uint32
    Access type: Read-only
    Qualifiers: Key

    Type of site control file. This property is no longer used for queries. Values are:
    EMPTY (0)
    ACTUAL (1)
    PROPOSED (2)
    TRANSACTIONS (4)
    LOCAL_TRANSACTIONS (6)

  • ItemName
    Data type: string
    Access type: Read-only
    Qualifiers: Key

    Unique identifier of a site-control item.

  • ItemType
    Data type: string
    Access type: Read-only
    Qualifiers: Key

    Unique identifier of a site-control item.

  • LatestBeginTime
    Data type: datetime
    Access type: Read/write

    Latest beginning time for the (SQL) command. Note that only the hours and minutes of this property are used.

  • LogFile
    Data type: string
    Access type: Read/write

    Logfile to which to write the output.

  • Name
    Data type: string
    Access type: Read/write

    User-defined name given to the SQL command.

  • NumRefreshDays
    Data type: uint32
    Access type: Read/write

    Number of days between task execution.

  • On
    Data type: boolean
    Access type: Read/write

    Indicates whether the SQL command is activated.

  • SiteCode
    Data type: string
    Access type: Read-only
    Qualifiers: Key

    Site code of the site server.

  • SQLCmd
    Data type: string
    Access type: Read/write

    SQL command to execute.

See Also

Site Configuration Classes, SMS_SCI_SQLTask