Jaa


StartTime Element for HostedProvider/Schedule (ADF)

Specifies a time of day (24 hour period) in UTC which is used as a starting point to calculate each of the invocation times for the event provider.

Syntax

<Providers>
    <HostedProvider>
        ...
        <Schedule>
            <StartTime>

Element Characteristics

Characteristic Description

Data type

string, between 1 and 512 characters in length.

Default value

None.

Occurrence

Optional once per Schedule element.

Updates

Can be added, deleted, and modified when updating the application.

Element Relationships

Relationship Elements

Parent element

Schedule Element for HostedProvider (ADF)

Child elements

None.

Remarks

The StartTime value must conform to the Microsoft .NET Framework string representation of a DateTime data type. 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.

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

Schedule Values and Description

Every hour on the half hour

StartTime 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, … , 23:30).

Every 3 hours on the hour starting at 1:00

StartTime 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 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 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 to specify a start time of 1:00 (UTC).

<StartTime>1:00</StartTime>

See Also

Reference

Application Definition File Reference

Other Resources

Defining Hosted Event Providers
Updating Instances and Applications

Help and Information

Getting SQL Server 2005 Assistance