Classe TransferJobsTask
Provides the methods and properties to transfer SQL Server Agent jobs from one instance of SQL Server to another.
Hierarquia de herança
System. . :: . .Object
Microsoft.SqlServer.Dts.Runtime. . :: . .DtsObject
Microsoft.SqlServer.Dts.Runtime. . :: . .Task
Microsoft.SqlServer.Dts.Tasks.TransferJobsTask..::..TransferJobsTask
Namespace: Microsoft.SqlServer.Dts.Tasks.TransferJobsTask
Assembly: Microsoft.SqlServer.TransferJobsTask (em Microsoft.SqlServer.TransferJobsTask.dll)
Sintaxe
'Declaração
<GuidAttribute("A3859AE1-B057-465e-B106-51CAA03F8532")> _
Public NotInheritable Class TransferJobsTask _
Inherits Task _
Implements ITransferJobsTask, IDTSBreakpointSite, IDTSSuspend, IDTSComponentPersist
'Uso
Dim instance As TransferJobsTask
[GuidAttribute("A3859AE1-B057-465e-B106-51CAA03F8532")]
public sealed class TransferJobsTask : Task,
ITransferJobsTask, IDTSBreakpointSite, IDTSSuspend, IDTSComponentPersist
[GuidAttribute(L"A3859AE1-B057-465e-B106-51CAA03F8532")]
public ref class TransferJobsTask sealed : public Task,
ITransferJobsTask, IDTSBreakpointSite, IDTSSuspend, IDTSComponentPersist
[<SealedAttribute>]
[<GuidAttribute("A3859AE1-B057-465e-B106-51CAA03F8532")>]
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
O tipo TransferJobsTask expõe os membros a seguir.
Construtores
Nome | Descrição | |
---|---|---|
TransferJobsTask | Initializes a new instance of the TransferJobsTask class. |
Início
Propriedades
Nome | Descrição | |
---|---|---|
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. (Substitui 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. (Herdado de Task.) |
Início
Métodos
Nome | Descrição | |
---|---|---|
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. (Herdado de Task.) | |
Equals | Determines whether two object instances are equal. (Herdado de DtsObject.) | |
Execute | Runs the task. (Substitui Task. . :: . .Execute(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging, Object).) | |
Finalize | (Herdado de Object.) | |
GetConnectionID | Gets a String containing the ID of the connection. (Herdado de Task.) | |
GetConnectionName | Gets a String containing the name of the connection. (Herdado de Task.) | |
GetHashCode | Returns the hash code for this instance. (Herdado de DtsObject.) | |
GetType | (Herdado de Object.) | |
InitializeTask | Initializes the properties associated with the task. This method is called by the runtime and is not used in code. (Substitui 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 | (Herdado de 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 | (Herdado de Object.) | |
Update | *** Member deprecated; see Remarks. *** This method updates the old package XML with the new package XML if CanUpdate is set to true. (Herdado de Task.) | |
Validate | Verifies that the task is correctly configured. (Substitui Task. . :: . .Validate(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging).) |
Início
Segurança de thread
Qualquer membro público static (Shared no Visual Basic) desse tipo é seguro para threads. Não há garantia de que qualquer membro de instância seja seguro para threads.