DbMaintenanceHistoryCleanupTask Constructor

Article
04/28/2008

[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]

Initializes a new instance of the ExecuteSQLTask class.

Namespace: Microsoft.SqlServer.Management.DatabaseMaintenance
Assembly: Microsoft.SqlServer.MaintenancePlanTasks (in microsoft.sqlserver.maintenanceplantasks.dll)

Syntax

'Declaration
Public Sub New

public DbMaintenanceHistoryCleanupTask ()

public:
DbMaintenanceHistoryCleanupTask ()

public DbMaintenanceHistoryCleanupTask ()

public function DbMaintenanceHistoryCleanupTask ()

Remarks

The code sample shows how to call the task constructor. However, in most cases, you will be creating the task as a member of a package. For more information on casting the task, see the remarks in Add.

Package pkg = new Package();
Executable exec1 = pkg.Executables.Add("STOCK:SQLTask");
TaskHost th = exec1 as TaskHost;
// You can cast the InnerObject of the TaskHost
// to the specific class.
// For the code samples, the task properties are accessed by using
// the properties collection of the TaskHost.
// SQLTask myTask = th.InnerObject as SQLTask;

Dim pkg As Package =  New Package() 
Dim exec1 As Executable =  pkg.Executables.Add("STOCK:SQLTask") 
Dim th As TaskHost =  exec1 as TaskHost 
' You can cast the InnerObject of the TaskHost
' to the specific class.
' For the code samples, the task properties are accessed by using
' the Properties collection of the TaskHost.
' Dim myTask As SQLTask =  th.InnerObject as SQLTask

The properties and methods of the ExecuteSQLTask are available by using the TaskHost variable, th.

Example

The following code sample creates a new ExecuteSQLTask by using the constructor.

SQLTask myTask = new SQLTask();

Dim myTask As SQLTask =  New SQLTask()

Platforms

Development Platforms

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

Target Platforms

Windows 98, Windows 2000, Windows 2000 Server, Windows CE, Windows Server 2008, Windows 98 Second Edition, Pocket PC, Smart Phone, Windows Server 2003, Windows XP Professional with Service Pack 2 (SP2), Windows 2000 Professional, Windows 2000 Advanced Server, Windows XP Home Edition, For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server., Windows Vista, Windows Mobile 5.0, Windows Mobile 2003 for Pocket PC, Windows CE 5.0

Share via