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)