VacuumSchedule Constructor ()

Article
12/03/2008

Initializes a new instance of the VacuumSchedule class.

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

Syntax

'Declaration
Public Sub New

public VacuumSchedule ()

public:
VacuumSchedule ()

public VacuumSchedule ()

public function VacuumSchedule ()

Remarks

Updated text:5 December 2005

Updated sample code:5 December 2005

If you use the default constructor, you must immediately set the Name property and then set the Parent property. When using this constructor, you must also set the Interval and StartTime properties.

Example

The following examples show how to use this default constructor to define a single data removal period:

// Define a data removal schedule and set properties.
VacuumSchedule vacuumSchedule1 = new VacuumSchedule();
vacuumSchedule1.Name = "vac1";
vacuumSchedule1.Parent = myApplication;
vacuumSchedule1.Interval = new TimeSpan(6, 0, 0);
vacuumSchedule1.StartTime = new TimeSpan(23, 0, 0);
myApplication.VacuumSchedules.Add(vacuumSchedule1);

' Define a data removal schedule and set properties.
Dim vacuumSchedule1 As VacuumSchedule = New VacuumSchedule()
vacuumSchedule1.Name = "vac1"
vacuumSchedule1.Parent = myApplication
vacuumSchedule1.Interval = New TimeSpan(6, 0, 0)
vacuumSchedule1.StartTime = New TimeSpan(23, 0, 0)
myApplication.VacuumSchedules.Add(vacuumSchedule1)

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.

Share via