TransferJobsTask 类
Provides the methods and properties to transfer SQL Server Agent jobs from one instance of SQL Server to another.
继承层次结构
System.Object
Microsoft.SqlServer.Dts.Runtime.DtsObject
Microsoft.SqlServer.Dts.Runtime.Task
Microsoft.SqlServer.Dts.Tasks.TransferJobsTask.TransferJobsTask
命名空间: Microsoft.SqlServer.Dts.Tasks.TransferJobsTask
程序集: Microsoft.SqlServer.TransferJobsTask(在 Microsoft.SqlServer.TransferJobsTask.dll 中)
语法
声明
<GuidAttribute("DB493BD0-194A-47BA-8084-511537354DD4")> _
Public NotInheritable Class TransferJobsTask _
Inherits Task _
Implements ITransferJobsTask, IDTSBreakpointSite, IDTSSuspend, IDTSComponentPersist
用法
Dim instance As TransferJobsTask
[GuidAttribute("DB493BD0-194A-47BA-8084-511537354DD4")]
public sealed class TransferJobsTask : Task,
ITransferJobsTask, IDTSBreakpointSite, IDTSSuspend, IDTSComponentPersist
[GuidAttribute(L"DB493BD0-194A-47BA-8084-511537354DD4")]
public ref class TransferJobsTask sealed : public Task,
ITransferJobsTask, IDTSBreakpointSite, IDTSSuspend, IDTSComponentPersist
[<SealedAttribute>]
[<GuidAttribute("DB493BD0-194A-47BA-8084-511537354DD4")>]
type TransferJobsTask =
class
inherit Task
interface ITransferJobsTask
interface IDTSBreakpointSite
interface IDTSSuspend
interface IDTSComponentPersist
end
public final class TransferJobsTask extends Task implements ITransferJobsTask, IDTSBreakpointSite, IDTSSuspend, IDTSComponentPersist
TransferJobsTask 类型公开以下成员。
构造函数
名称 | 说明 | |
---|---|---|
TransferJobsTask | Initializes a new instance of the TransferJobsTask class. |
页首
属性
名称 | 说明 | |
---|---|---|
DebugMode | Gets or sets a Boolean indicating whether a task should determine whether breakpoints are enabled. | |
DestinationConnection | Gets or sets a String containing the name of the SMO connection manager for the destination database. | |
EnableJobsAtDestination | Gets or sets a Boolean indicating whether the jobs created at the destination should be enabled. | |
ExecutionValue | Returns an object containing the number of jobs transfered. (覆盖 Task.ExecutionValue。) | |
IfObjectExists | Gets or sets a value from the IfObjectExists enumeration indicating indicating if the task should fail, overwrite the existing job, or skip the transfer of the job if a job with the same name exists at the destination. | |
JobsList | Gets or sets a StringCollection containing the names of the jobs to transfer. | |
SourceConnection | Gets or sets a String containing the name of the SMO connection manager for the source database. | |
SuspendRequired | Gets or sets a Boolean indicating whether tasks should suspend when they encounter a breakpoint. This value is set by the run-time engine for tasks and containers when a breakpoint is encountered. | |
TransferAllJobs | Gets or sets a Boolean indicating if some or all jobs are transferred. | |
Version | *** Member deprecated; see Remarks. *** Returns the version of the task. This property is read-only. (从 Task 继承。) |
页首
方法
名称 | 说明 | |
---|---|---|
AcceptBreakpointManager | Called by the run-time engine when a task or container is created, and is passed a BreakpointManager to enable the task to create, remove, and check the status of breakpoints. This method is called by the runtime and is not used in code. | |
CanUpdate | *** Member deprecated; see Remarks. *** A Boolean that indicates whether the new package XML can update the old package XML. (从 Task 继承。) | |
Equals | Determines whether two object instances are equal. (从 DtsObject 继承。) | |
Execute | Runs the task. (覆盖 Task.Execute(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging, Object)。) | |
GetConnectionID | Gets a String containing the ID of the connection. (从 Task 继承。) | |
GetConnectionName | Gets a String containing the name of the connection. (从 Task 继承。) | |
GetHashCode | Returns the hash code for this instance. (从 DtsObject 继承。) | |
GetType | (从 Object 继承。) | |
InitializeTask | Initializes the properties associated with the task. This method is called by the runtime and is not used in code. (覆盖 Task.InitializeTask(Connections, VariableDispenser, IDTSInfoEvents, IDTSLogging, EventInfos, LogEntryInfos, ObjectReferenceTracker)。) | |
LoadFromXML | This method is not callable by your application code. To load a package saved as .xml, use the Application.LoadPackage method. | |
ResumeExecution | Resumes execution of the task after pausing. The task or container is resumed by the run-time engine. | |
SaveToXML | This method is not callable by your application code. To save a package as .xml, use the Application.SaveToXml method. | |
SuspendExecution | Indicates that the executable needs to suspend. This method is called by the run-time engine. | |
ToString | (从 Object 继承。) | |
Update | *** Member deprecated; see Remarks. *** This method updates the old package XML with the new package XML if CanUpdate is set to true. (从 Task 继承。) | |
Validate | Verifies that the task is correctly configured. (覆盖 Task.Validate(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging)。) |
页首
线程安全
此类型的任何公共 static(在 Visual Basic 中为 Shared) 成员都是线程安全的。不保证所有实例成员都是线程安全的。