SubscriptionConditionScheduledRule Constructor ()

Initializes a new instance of the SubscriptionConditionScheduledRule class.

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

Sintaxis

'Declaración
Public Sub New

public SubscriptionConditionScheduledRule ()

public:
SubscriptionConditionScheduledRule ()

public SubscriptionConditionScheduledRule ()

public function SubscriptionConditionScheduledRule ()

Notas

Texto actualizado:5 de diciembre de 2005

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

When using the default constructor, first set the Name, then the Parent, and then other properties. This constructor does not set any property values.

Ejemplo

The following examples show how to use this default constructor to create 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)

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