HostedEventProvider.StartTime Property

Article
12/15/2008

Gets or sets a time of day used to calculate each of the invocation times for the hosted event provider.

Espace de noms: Microsoft.SqlServer.Management.Nmo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

Syntaxe

'Déclaration
Public Property StartTime As DateTime

public DateTime StartTime { get; set; }

public:
property DateTime StartTime {
    DateTime get ();
    void set (DateTime value);
}

/** @property */
public DateTime get_StartTime ()

/** @property */
public void set_StartTime (DateTime value)

public function get StartTime () : DateTime

public function set StartTime (value : DateTime)

Valeur de propriété

A DateTime object that specifies the event provider start time.

Notes

The StartTime value must be specified in UTC.

If you do not provide a StartTime value, Notification Services runs the event provider for the first time when the instance starts or when you enable the event provider.

If you do provide a StartTime value, Notification Services runs the provider as follows:

Notification Services calculates the invocation times for the 24-hour period starting at the StartTime value.
Notification Services first invokes the event provider at the next calculated invocation time.

To remove a start time value, set the value to DateTime.MinValue. Notification Services uses the value to set the StartTime to NULL when you update the application.

The table shows examples of invocation schedules given various StartTime and Interval values.

Schedule	Values and Description
Every hour on the half hour	StartTime time value is 1:30 (or any other half hour). Interval value is PT1H. The event provider first runs at the next half-hour, such as 0:30, 1:30, 2:30, and so on, up to 23:30).
Every 3 hours on the hour starting at 1:00	StartTime time value is 1:00. Interval value is PT3H. The event provider first runs at the next 3-hour interval in the following list: 1:00, 4:00, 7:00, 10:00, 13:00, 16:00, 19:00, 22:00.
Every 6 hours starting at 12:00	StartTime time value is 12:00. Interval value is PT6H. The event provider first runs at the next 6-hour interval in the following list: 0:00, 6:00, 12:00, 18:00.
At 4:00 each day	StartTime time value is 4:00. Interval value is PT24H. The event provider runs at 4:00 each day regardless of what time it is started.

Exemple

The following example shows how define a hosted event provider with no start time. This event provider runs as soon as the event provider host starts.

// Define a hosted event provider and set properties.
HostedEventProvider flightEventProvider = new HostedEventProvider();
flightEventProvider.Parent = myApplication;
flightEventProvider.Name = "FlightEP";
flightEventProvider.StartTime = DateTime.MinValue;
flightEventProvider.Timeout = new TimeSpan(0, 5, 0);
flightEventProvider.ClassName = "FileSystemWatcherProvider";
flightEventProvider.AssemblyName = "";
flightEventProvider.SystemName = notificationServicesHost;

' Define a hosted event provider and set properties.
Dim flightEventProvider As HostedEventProvider = _
    New HostedEventProvider()
flightEventProvider.Parent = myApplication
flightEventProvider.Name = "FlightEP"
flightEventProvider.StartTime = DateTime.MinValue
flightEventProvider.Timeout = New TimeSpan(0, 5, 0)
flightEventProvider.ClassName = "FileSystemWatcherProvider"
flightEventProvider.AssemblyName = ""
flightEventProvider.SystemName = notificationServicesHost

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

HostedEventProvider Class
HostedEventProvider Members
Microsoft.SqlServer.Management.Nmo Namespace

Autres ressources

Définition de fournisseurs d'événements hébergés
StartTime Element for HostedProvider/Schedule (ADF)

Partager via