SubscriptionConditionScheduledRule.Parent Property

Gets or sets the parent SubscriptionClass object for the SubscriptionConditionScheduledRule.

Espacio de nombres: Microsoft.SqlServer.Management.Nmo
Ensamblado: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

Sintaxis

'Declaración
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)

Valor de propiedad

The parent SubscriptionClass object.

Notas

Texto actualizado:5 de diciembre de 2005

Código de ejemplo actualizado:5 de diciembre de 2005

Each SubscriptionConditionScheduledRule has a parent SubscriptionClass. You typically supply the parent object when you create the SubscriptionConditionScheduledRule using the SubscriptionConditionScheduledRule(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.

Ejemplo

The following examples show how to set the Parent property when using the default constructor to created a condition-based, scheduled rule and then add the rule to a subscription class:

// Create a condition-based scheduled rule and set properties.
SubscriptionConditionScheduledRule flightConditionScheduledRule = 
    new SubscriptionConditionScheduledRule();
flightConditionScheduledRule.Name = "FlightConditionScheduledRule";
flightConditionScheduledRule.Parent = flightSubscriptions;
flightConditionScheduledRule.ActionTimeout = new TimeSpan(0, 30, 0);
flightConditionScheduledRule.SqlLoginName = "MyLowPrivLogin";
flightConditionScheduledRule.SqlUserName = "MyLowPrivUser";
flightConditionScheduledRule.InputTypeName = "FlightEventChronicle";
flightConditionScheduledRule.InputTypeSchema = "dbo";
flightConditionScheduledRule.SqlExpression = 
    "INSERT INTO dbo.FlightNotifications (SubscriberId, " +
    "DeviceName, SubscriberLocale, LeavingFrom, GoingTo, Price) " +
    "SELECT [Subscription.SubscriberId], " +
    "[Subscription.DeviceName], [Subscription.SubscriberLocale], " +
    "[Input.LeavingFrom], [Input.GoingTo], [Input.Price] " +
    "FROM dbo.FlightConditionScheduledRule;";
flightSubscriptions.SubscriptionConditionScheduledRules.Add(flightConditionScheduledRule);

' Create a condition-based scheduled rule and set properties.
Dim flightConditionScheduledRule As SubscriptionConditionScheduledRule = _
    New SubscriptionConditionScheduledRule()
flightConditionScheduledRule.Name = "FlightConditionScheduledRule"
flightConditionScheduledRule.Parent = flightSubscriptions
flightConditionScheduledRule.ActionTimeout = New TimeSpan(0, 30, 0)
flightConditionScheduledRule.SqlLoginName = "MyLowPrivLogin"
flightConditionScheduledRule.SqlUserName = "MyLowPrivUser"
flightConditionScheduledRule.InputTypeName = "FlightEventChronicle"
flightConditionScheduledRule.InputTypeSchema = "dbo"
flightConditionScheduledRule.SqlExpression = _
    "INSERT INTO dbo.FlightNotifications (SubscriberId, " + _
    "DeviceName, SubscriberLocale, LeavingFrom, GoingTo, Price) " + _
    "SELECT [Subscription.SubscriberId], " + _
    "[Subscription.DeviceName], [Subscription.SubscriberLocale], " + _
    "[Input.LeavingFrom], [Input.GoingTo], [Input.Price] " + _
    "FROM dbo.FlightConditionScheduledRule;"
flightSubscriptions.SubscriptionConditionScheduledRules.Add( _
    flightConditionScheduledRule)

Seguridad para subprocesos

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.

Plataformas

Plataformas de desarrollo

Para obtener una lista de las plataformas compatibles, vea Requisitos de hardware y software para instalar SQL Server 2005.

Plataformas de destino

Para obtener una lista de las plataformas compatibles, vea Requisitos de hardware y software para instalar SQL Server 2005.

Vea también

Referencia

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

Otros recursos

Definir reglas programadas
Definir acciones de condición
ScheduledRule Element (ADF)
ConditionAction Element (ADF)