SubscriptionConditionScheduledRule Constructor ()
Initializes a new instance of the SubscriptionConditionScheduledRule class.
Espace de noms: Microsoft.SqlServer.Management.Nmo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
Syntaxe
'Déclaration
Public Sub New
public SubscriptionConditionScheduledRule ()
public:
SubscriptionConditionScheduledRule ()
public SubscriptionConditionScheduledRule ()
public function SubscriptionConditionScheduledRule ()
Notes
Texte mis à jour :5 décembre 2005
Exemple de code mis à jour :5 décembre 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.
Exemple
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)
Plateformes
Plateformes de développement
Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.
Plateformes cibles
Pour obtenir la liste des plateformes prises en charge, consultez Configuration matérielle et logicielle requise pour l'installation de SQL Server 2005.
Voir aussi
Référence
SubscriptionConditionScheduledRule Class
SubscriptionConditionScheduledRule Members
Microsoft.SqlServer.Management.Nmo Namespace