VacuumSchedule Constructor (Application, String)
Initializes a new instance of the VacuumSchedule class with an Application object and a name.
Namespace: Microsoft.SqlServer.Management.Nmo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
Syntax
'Declaration
Public Sub New ( _
application As Application, _
name As String _
)
public VacuumSchedule (
Application application,
string name
)
public:
VacuumSchedule (
Application^ application,
String^ name
)
public VacuumSchedule (
Application application,
String name
)
public function VacuumSchedule (
application : Application,
name : String
)
Parameters
- application
The parent Application for the data removal schedule.
name
A String that specifies the name of the VacuumSchedule object. Notification Services does not use this name. This name is not used by Notification Services.You cannot change the name. To rename a vacuum schedule, you must remove the schedule and then add a new schedule that has the new name.
Remarks
During reflection, the name becomes the vacuum schedule ID that Notification Services generates when it adds the vacuum schedule to the application database.
When using this constructor, you must set the StartTime property.
This constructor sets the default value for the Interval property to 6 hours.
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)
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
VacuumSchedule Class
VacuumSchedule Members
Microsoft.SqlServer.Management.Nmo Namespace