Share via


DbMaintenanceExecuteAgentJobTask Members

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

The following tables list the members exposed by the DbMaintenanceExecuteAgentJobTask type.

Public Constructors

  Name Description
DbMaintenanceExecuteAgentJobTask Initializes a new instance of the ExecuteSQLTask class.

Top

Public Properties

(see also Protected Properties )

  Name Description
AgentJobId  
BypassPrepare  Gets or sets a Boolean that indicates whether the Execute SQL task skips preparation of the statement when sending the SQL statement to the relational database management system (RDBMS). (inherited from ExecuteSQLTask)
CodePage  Gets or sets the code page to use when translating variable values that are stored as Unicode wide chars to multi-bytes. Translation occurs either when storing values to or extracting values from databases. (inherited from ExecuteSQLTask)
Connection  Gets or sets the name of the connection manager that connects to the relational database management system (RDBMS) where the Execute SQL task is run. (inherited from ExecuteSQLTask)
DatabaseSelectionType  (inherited from DatabaseMaintenanceBaseTask )
Description  
ExecutionValue  Returns the number of rows affected by the SQL statement or statements. (inherited from ExecuteSQLTask)
ExtendedLogging  (inherited from DatabaseMaintenanceBaseTask )
IsStoredProcedure  Gets or sets a Boolean that indicates whether the SQL statement specified by the Execute SQL task is a stored procedure. (inherited from ExecuteSQLTask)
LocalConnectionForLogging  (inherited from DatabaseMaintenanceBaseTask )
ObjectTypeSelection  (inherited from DatabaseMaintenanceBaseTask )
ParameterBindings  Returns an object that implements IDTSParameterBindings. (inherited from ExecuteSQLTask)
ResultSetBindings  Returns an object that implements IDTSParameterBindings. (inherited from ExecuteSQLTask)
ResultSetType  Gets or sets a value that indicates the type of result set returned by the SQL statement that the Execute SQL tasks runs. (inherited from ExecuteSQLTask)
RunId  (inherited from DatabaseMaintenanceBaseTask )
SelectedDatabases  (inherited from DatabaseMaintenanceBaseTask )
SelectedTables  (inherited from DatabaseMaintenanceBaseTask )
ServerVersion  (inherited from DatabaseMaintenanceBaseTask )
SqlStatementSource  Gets or sets the name of the source that contains the SQL statement that the Execute SQL task runs. (inherited from ExecuteSQLTask)
SqlStatementSourceType  Gets or sets a value that indicates the type of source that contains the SQL statement that the Execute SQL task runs. (inherited from ExecuteSQLTask)
TableSelectionType  (inherited from DatabaseMaintenanceBaseTask )
TaskAllowesDatbaseSelection  
TaskAllowesTableSelection  
TaskConnectionName  (inherited from DatabaseMaintenanceBaseTask )
TaskName  (inherited from DatabaseMaintenanceBaseTask )
TaskNameWasModified  (inherited from DatabaseMaintenanceBaseTask )
TimeOut  Gets or sets an integer that indicates the maximum number of seconds the task can run before timing out. (inherited from ExecuteSQLTask)
Version  *** Member deprecated; see Remarks. ***   Returns the version of the task. This property is read-only. (inherited from Task)

Top

Protected Properties

  Name Description
SqlBatchCommands  (inherited from DatabaseMaintenanceBaseTask )

Top

Public Methods

(see also Protected Methods )

  Name Description
CanDowngradeTo  (inherited from DatabaseMaintenanceBaseTask )
CanUpdate  (inherited from Task )
CopyTo Overridden.  
DowngradeTo  (inherited from DatabaseMaintenanceBaseTask )
Equals  Overloaded. (inherited from DtsObject )
Execute Overridden.  
GetConnectionID  (inherited from Task )
GetConnectionName  (inherited from Task )
GetHashCode  Returns the hash code for this instance. (inherited from DtsObject)
GetType  (inherited from Object )
InitializeTask  (inherited from DatabaseMaintenanceBaseTask )
LoadFromXML  
OnAddedToTaskHost  (inherited from DatabaseMaintenanceBaseTask )
op_Equality  (inherited from DtsObject )
op_Inequality  (inherited from DtsObject )
ReferenceEquals  (inherited from Object )
SaveToXML  
ToString  (inherited from Object )
Update  (inherited from Task )
Validate Overridden.  

Top

Protected Methods

  Name Description
Finalize  (inherited from Object )
MemberwiseClone  (inherited from Object )
WriteToDTSLog  (inherited from DatabaseMaintenanceBaseTask )

Top

See Also

Reference

DbMaintenanceExecuteAgentJobTask Class
Microsoft.SqlServer.Management.DatabaseMaintenance Namespace