Export (0) Print
Expand All

VacuumSchedule Class

SQL Server 2005

Define the vacuuming (data removal) schedule for the Notification ServicesApplication.

Namespace: Microsoft.SqlServer.Management.Nmo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)

public sealed class VacuumSchedule : 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 Configuring Data Removal.

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.


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);

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.

Development Platforms

For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server 2005.

Target Platforms

Community Additions

ADD
Show:
© 2014 Microsoft