SubscriptionConditionScheduledRule.Parent Property
Gets or sets the parent SubscriptionClass object for the SubscriptionConditionScheduledRule.
Espace de noms: Microsoft.SqlServer.Management.Nmo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
Syntaxe
'Déclaration
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)
Valeur de propriété
The parent SubscriptionClass object.
Notes
Texte mis à jour :5 décembre 2005
Exemple de code mis à jour :5 décembre 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.
Exemple
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)
Sécurité des threads
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.
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
Autres ressources
Définition de règles planifiées
Définition des actions de condition
ScheduledRule Element (ADF)
ConditionAction Element (ADF)