Application.VacuumSchedules Property

Gets the data removal schedule for the application.

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

Syntax

'Declaration
Public ReadOnly Property VacuumSchedules As VacuumScheduleCollection

public VacuumScheduleCollection VacuumSchedules { get; }

public:
property VacuumScheduleCollection^ VacuumSchedules {
    VacuumScheduleCollection^ get ();
}

/** @property */
public VacuumScheduleCollection get_VacuumSchedules ()

public function get VacuumSchedules () : VacuumScheduleCollection

Property Value

A VacuumScheduleCollection object containing the data removal schedule.

Remarks

Use the methods of the VacuumScheduleCollection class to add or remove VacuumSchedule objects.

Example

The following examples show how to define a vacuum schedule and add it to an 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)

Thread Safety

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.

Platforms

Development Platforms

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

Target Platforms

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

See Also

Reference

Application Class
Application Members
Microsoft.SqlServer.Management.Nmo Namespace
VacuumSchedule

Other Resources

Configuring Data Removal
Removing Obsolete Application Data
VacuumSchedule Element (ADF)