SubscriptionConditionScheduledRule Constructor ()

2008-12-15

Initializes a new instance of the SubscriptionConditionScheduledRule class.

命名空间: Microsoft.SqlServer.Management.Nmo
程序集: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

语法

声明
Public Sub New

public SubscriptionConditionScheduledRule ()

public:
SubscriptionConditionScheduledRule ()

public SubscriptionConditionScheduledRule ()

public function SubscriptionConditionScheduledRule ()

备注

已更新的文本：2005 年 12 月 5 日

已更新的示例代码：2005 年 12 月 5 日

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

示例

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)