Share via

SMS_SCI_SQLTask

  • Article

The SMS_SCI_SQLTask WMI class defines a Structured Query Language (SQL) task to be run periodically.

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

Properties

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

    Beginning time of the SQL task. Note that 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. Bit field flags are:
    SUNDAY (0)
    MONDAY (1)
    TUESDAY (2)
    WEDNESDAY (3)
    THURSDAY (4)
    FRIDAY (5)
    SATURDAY (6)

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

    Number of days after which records are deleted if the TaskType property is DELETE.

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

    Device name if the TaskType property is BACKUP.

  • 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/write
    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) task. Note that only the hours and minutes of this property are used.

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

    Number of days between task execution.

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

    Indicates that the task is active.

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

    Site code of the site server.

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

    Task name. SMS-defined task names are:

    Dump SMS Database Dump SMS Transaction Log Dump Licensing Database Dump Licensing Transaction Log Update Statistics Rebuild Indexes Monitor Keys and Recreate Views Delete Aged Inventory History Delete Aged Status Objects Delete Aged Discovery Data Delete Aged Collected Files

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

    Task type. Values are:
    BACKUP (1)
    PERIOD (2)
    DELETE (3)

See Also

Site Configuration Classes, SMS_SCI_SQLCmd