共用方式為


HostedEventProvider.StartTime Property

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

命名空間: Microsoft.SqlServer.Management.Nmo
組件: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

語法

'宣告
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)

屬性值

A DateTime object that specifies the event provider start time.

備註

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.

範例

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

執行緒安全性

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.

平台

開發平台

如需受支援的平台清單,請參閱<安裝 SQL Server 2005 的硬體和軟體需求>。

目標平台

如需受支援的平台清單,請參閱<安裝 SQL Server 2005 的硬體和軟體需求>。

請參閱

參考

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

其他資源

定義裝載的事件提供者
StartTime Element for HostedProvider/Schedule (ADF)