Share via


HostedEventProvider.StartTime Property

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

Namespace: Microsoft.SqlServer.Management.Nmo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

Syntax

'Declaration
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)

Property Value

A DateTime object that specifies the event provider start time.

Remarks

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.

Example

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

Thread Safety

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.

Platforms

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

See Also

Reference

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

Other Resources

Defining Hosted Event Providers
StartTime Element for HostedProvider/Schedule (ADF)