ActiveStartTimeOfDay Property

この機能は、将来のバージョンの Microsoft SQL Server では削除される予定です。新規の開発作業ではこの機能を使用しないようにし、現在この機能を使用しているアプリケーションは修正することを検討してください。

The ActiveStartTimeOfDay property indicates the first effective time for a schedule.

構文

object
.
ActiveStartTimeOfDay [=value]

Parts

• object
  An expression that evaluates to an object in the Applies To list.

• value
  A long integer representing a time.

Data Type

Long

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetActiveStartTimeOfDay(LPLONG pRetVal);
HRESULT SetActiveStartTimeOfDay(LONG NewValue);

解説

Scheduled SQL Server Agent activities, such as jobs, can have begin and end times. A job is run at the points indicated in a schedule only between the begin time and the end time. Alter the ActiveStartTimeOfDay property to set the time at which the schedule becomes effective.

メモ :
When SQL Distributed Management Objects (SQL-DMO) uses a scaled long integer to represent a time, the integer is built as a sum of the hour scaled by 10000, the minute scaled by 100, and the seconds. The time value uses a 24-hour clock. For example, the time 1:03:09 P.M. is represented by the long integer value 130309.

Applies To:

Schedule Object