Gets or sets the duration the data removal process is allowed to run after it has been started.
네임스페이스: Microsoft.SqlServer.Management.Nmo
어셈블리: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
구문
‘선언
Public Property Interval As TimeSpan
public TimeSpan Interval { get; set; }
public:
property TimeSpan Interval {
TimeSpan get ();
void set (TimeSpan value);
}
/** @property */
public TimeSpan get_Interval ()
/** @property */
public void set_Interval (TimeSpan value)
public function get Interval () : TimeSpan
public function set Interval (value : TimeSpan)
속성 값
A TimeSpan object that specifies how long the vacuum process is allowed to run.
주의
The interval specifies the length of the vacuuming period, and cannot exceed 24 hours.
Vacuuming schedules cannot overlap. If schedules overlap, Notification Services stops the earlier vacuuming process before the later one starts.
예
The following examples show how to create a schedule for removing obsolete data and then add the schedule to the collection of vacuum schedules for the application:
VacuumSchedule vacuumSchedule1 = new VacuumSchedule(
myApplication, "1");
vacuumSchedule1.StartTime = new TimeSpan(23, 0, 0);
myApplication.VacuumSchedules.Add(vacuumSchedule1);
Dim vacuumSchedule1 As VacuumSchedule = _
New VacuumSchedule(myApplication, "1")
vacuumSchedule1.StartTime = New TimeSpan(23, 0, 0)
myApplication.VacuumSchedules.Add(vacuumSchedule1)
스레드 보안
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 설치를 위한 하드웨어 및 소프트웨어 요구 사항을 참조하십시오.
참고 항목
참조
VacuumSchedule Class
VacuumSchedule Members
Microsoft.SqlServer.Management.Nmo Namespace