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