SubscriptionScheduledRule.Parent Property

Статья
12/15/2008

Gets or sets the parent SubscriptionClass object for the scheduled rule.

Пространство имен: Microsoft.SqlServer.Management.Nmo
Сборка: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

Синтаксис

'Декларация
Public Property Parent As SubscriptionClass

public SubscriptionClass Parent { get; set; }

public:
property SubscriptionClass^ Parent {
    SubscriptionClass^ get ();
    void set (SubscriptionClass^ value);
}

/** @property */
public SubscriptionClass get_Parent ()

/** @property */
public void set_Parent (SubscriptionClass value)

public function get Parent () : SubscriptionClass

public function set Parent (value : SubscriptionClass)

Значение свойства

The parent SubscriptionClass object.

Замечания

Изменения текста5 декабря 2005 г.

Изменения образцов кода5 декабря 2005 г.

Each SubscriptionScheduledRule has a parent SubscriptionClass. You typically supply the parent object when you create the SubscriptionScheduledRule using the SubscriptionScheduledRule(SubscriptionClass,String) constructor.

If you set the parent in the constructor, do not set the parent using this property. Setting the parent twice throws an exception.

Пример

The following examples show how to set the Parent property when using the default constructor:

// Create a scheduled rule and set properties.
SubscriptionScheduledRule flightScheduledRule = 
    new SubscriptionScheduledRule();
flightScheduledRule.Name = "FlightScheduledRule";
flightScheduledRule.Parent = flightSubscriptions;
flightScheduledRule.Action = "INSERT INTO FlightNotifications " + 
    "(SubscriberId, DeviceName, SubscriberLocale, " +
    " LeavingFrom, GoingTo, Price) " + 
    " SELECT S.SubscriberId, S.DeviceName, S.SubscriberLocale, " +
    " EC.LeavingFrom, EC.GoingTo, EC.Price " + 
    " FROM FlightEventChronicle EC, FlightSubscriptions S " +
    " WHERE EC.LeavingFrom = S.LeavingFrom " + 
    " AND EC.GoingTo = S.GoingTo " +
    " AND EC.Price < S.Price";
flightScheduledRule.ActionTimeout = new TimeSpan(0, 30, 0);
flightSubscriptions.SubscriptionScheduledRules.Add(
    flightScheduledRule);

' Create a scheduled rule and set properties.
Dim flightScheduledRule As SubscriptionScheduledRule = _
    New SubscriptionScheduledRule()
flightScheduledRule.Name = "FlightScheduledRule"
flightScheduledRule.Parent = flightSubscriptions
flightScheduledRule.Action = "INSERT INTO FlightNotifications " + _
    "(SubscriberId, DeviceName, SubscriberLocale, " + _
    " LeavingFrom, GoingTo, Price) " + _
    " SELECT S.SubscriberId, S.DeviceName, S.SubscriberLocale, " + _
    " EC.LeavingFrom, EC.GoingTo, EC.Price " + _
    " FROM FlightEventChronicle EC, FlightSubscriptions S " + _
    " WHERE EC.LeavingFrom = S.LeavingFrom " + _
    " AND EC.GoingTo = S.GoingTo " + _
    " AND EC.Price < S.Price"
flightScheduledRule.ActionTimeout = New TimeSpan(0, 30, 0)
flightSubscriptions.SubscriptionScheduledRules.Add(flightScheduledRule)

Синхронизация потоков

Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.

Платформы

Платформы разработки

Список поддерживаемых платформ см. в разделе Hardware and Software Requirements for Installing SQL Server 2005.

Целевые платформы

Список поддерживаемых платформ см. в разделе Hardware and Software Requirements for Installing SQL Server 2005.

См. также

Справочник

SubscriptionScheduledRule Class
SubscriptionScheduledRule Members
Microsoft.SqlServer.Management.Nmo Namespace

Другие ресурсы

Определение запланированных правил
ScheduledRule Element (ADF)

Поделиться через