VacuumSchedule Class
Define the vacuuming (data removal) schedule for the Notification ServicesApplication.
命名空間: Microsoft.SqlServer.Management.Nmo
組件: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
語法
'宣告
Public NotInheritable Class VacuumSchedule
Inherits NamedSmoObject
public sealed class VacuumSchedule : NamedSmoObject
public ref class VacuumSchedule sealed : public NamedSmoObject
public final class VacuumSchedule extends NamedSmoObject
public final class VacuumSchedule extends NamedSmoObject
備註
Vacuuming removes older event and notification data from the application database. For more information about the vacuuming process, see 設定資料移除.
The vacuuming process runs daily at the specified times for the specified duration.
Vacuuming schedules cannot overlap. If schedules overlap, Notification Services stops the earlier vacuuming process before the later one starts.
Vacuuming schedules are optional, and an application can have multiple vacuum schedules. If you do not specify at least one vacuum schedule, obsolete data is not removed from the application database.
Inheritance Hierarchy
System.Object
Microsoft.SqlServer.Management.Smo.SmoObjectBase
Microsoft.SqlServer.Management.Smo.SqlSmoObject
Microsoft.SqlServer.Management.Smo.NamedSmoObject
Microsoft.SqlServer.Management.Nmo.VacuumSchedule
範例
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 Members
Microsoft.SqlServer.Management.Nmo Namespace