TransferJobsTask 成員
Provides the methods and properties to transfer SQL Server Agent jobs from one instance of SQL Server to another.
TransferJobsTask 型別公開下列成員。
方法
| 名稱 | 描述 | |
|---|---|---|
.gif "公用方法") |
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)。) |
.gif "受保護的方法") |
Finalize | (繼承自 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. |
|
MemberwiseClone | (繼承自 Object。) |
|
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)。) |
頂端
屬性
| 名稱 | 描述 | |
|---|---|---|
.gif "公用屬性") |
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。) |
頂端