SubscriptionScheduledRule Constructor (SubscriptionClass, String)
Initializes a new instance of the SubscriptionScheduledRule class with a SubscriptionClass and a name.
Spazio dei nomi: Microsoft.SqlServer.Management.Nmo
Assembly : Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
Sintassi
'Dichiarazione
Public Sub New ( _
subscriptionClass As SubscriptionClass, _
name As String _
)
public SubscriptionScheduledRule (
SubscriptionClass subscriptionClass,
string name
)
public:
SubscriptionScheduledRule (
SubscriptionClass^ subscriptionClass,
String^ name
)
public SubscriptionScheduledRule (
SubscriptionClass subscriptionClass,
String name
)
public function SubscriptionScheduledRule (
subscriptionClass : SubscriptionClass,
name : String
)
Parametri
- subscriptionClass
The parent SubscriptionClass for the scheduled rule.
name
A String, between 1 and 255 characters in length, that specifies the name of the scheduled rule.You cannot change the name. To rename a rule, you must remove the rule and the add the rule with the new name.
Osservazioni
Each scheduled rule must have a name, and it must be unique within the application.
This constructor sets a default ActionTimeout value of 30 minutes.
Esempio
The following examples show how to define a scheduled rule and add it to a subscription class:
// Add a rule to generate basic scheduled notifications
SubscriptionScheduledRule flightScheduledRule =
new SubscriptionScheduledRule(
flightSubscriptions, "FlightScheduledRule");
flightScheduledRule.Action = "INSERT INTO FlightNotifications " +
"(SubscriberId, DeviceName, SubscriberLocale, " +
" LeavingFrom, GoingTo, Price) " +
" SELECT S.SubscriberId, S.DeviceName, S.SubscriberLocale, " +
" EC.LeavingFrom, EC.GoingTo, EC.Price " +
" FROM FlightEventChronicle EC, FlightSubscriptions S " +
" WHERE EC.LeavingFrom = S.LeavingFrom " +
" AND EC.GoingTo = S.GoingTo " +
" AND EC.Price < S.Price";
flightScheduledRule.ActionTimeout = new TimeSpan(0, 0, 30);
flightSubscriptions.SubscriptionScheduledRules.Add(
flightScheduledRule);
' Add a rule to generate basic scheduled notifications
Dim flightScheduledRule As SubscriptionScheduledRule = _
New SubscriptionScheduledRule(flightSubscriptions, _
"FlightScheduledRule")
flightScheduledRule.Action = _
"INSERT INTO FlightNotifications " + _
"(SubscriberId, DeviceName, SubscriberLocale, " + _
"LeavingFrom, GoingTo, Price) " + _
"SELECT S.SubscriberId, S.DeviceName, S.SubscriberLocale, " + _
"EC.LeavingFrom, EC.GoingTo, EC.Price " + _
"FROM FlightEventChronicle EC, FlightSubscriptions S " + _
"WHERE EC.LeavingFrom = S.LeavingFrom " + _
"AND EC.GoingTo = S.GoingTo " + _
"AND EC.Price < S.Price"
flightScheduledRule.ActionTimeout = New TimeSpan(0, 0, 30)
flightSubscriptions.SubscriptionScheduledRules.Add( _
flightScheduledRule)
Piattaforme
Piattaforme di sviluppo
Per un elenco delle piattaforme supportate, vedere Requisiti hardware e software per l'Installazione di SQL Server 2005.
Piattaforme di destinazione
Per un elenco delle piattaforme supportate, vedere Requisiti hardware e software per l'Installazione di SQL Server 2005.
Vedere anche
Riferimento
SubscriptionScheduledRule Class
SubscriptionScheduledRule Members
Microsoft.SqlServer.Management.Nmo Namespace
Altre risorse
Definizione delle regole pianificate
ScheduledRule Element (ADF)
RuleName Element for ScheduledRule (ADF)