แชร์ผ่าน

VacuumScheduleCollection.Add Method

  • บทความ

Adds a VacuumSchedule to the VacuumScheduleCollection.

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

Syntax

'Declaration
Public Sub Add ( _
    vacuumSchedule As VacuumSchedule _
)

public void Add (
    VacuumSchedule vacuumSchedule
)

public:
void Add (
    VacuumSchedule^ vacuumSchedule
)

public void Add (
    VacuumSchedule vacuumSchedule
)

public function Add (
    vacuumSchedule : VacuumSchedule
)

Parameters

Remarks

If you add VacuumSchedule objects after deploying the application, you must Update the instance to apply the changes.

Example

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)

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

VacuumScheduleCollection Class
VacuumScheduleCollection Members
Microsoft.SqlServer.Management.Nmo Namespace

Other Resources

Configuring Data Removal
Schedule Element for VacuumSchedule (ADF)