Membri TransferJobsTask
Provides the methods and properties to transfer SQL Server Agent jobs from one instance of SQL Server to another.
Il tipo TransferJobsTask espone i membri seguenti.
Costruttori
Nome | Descrizione | |
---|---|---|
TransferJobsTask | Initializes a new instance of the TransferJobsTask class. |
In alto
Metodi
Nome | Descrizione | |
---|---|---|
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. (Ereditato da Task). | |
Equals | Determines whether two object instances are equal. (Ereditato da DtsObject). | |
Execute | Runs the task. (Esegue l'override di Task. . :: . .Execute(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging, Object).) | |
Finalize | (Ereditato da Object). | |
GetConnectionID | Gets a String containing the ID of the connection. (Ereditato da Task). | |
GetConnectionName | Gets a String containing the name of the connection. (Ereditato da Task). | |
GetHashCode | Returns the hash code for this instance. (Ereditato da DtsObject). | |
GetType | (Ereditato da Object). | |
InitializeTask | Initializes the properties associated with the task. This method is called by the runtime and is not used in code. (Esegue l'override di 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 | (Ereditato da 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 | (Ereditato da Object). | |
Update | *** Member deprecated; see Remarks. *** This method updates the old package XML with the new package XML if CanUpdate is set to true. (Ereditato da Task). | |
Validate | Verifies that the task is correctly configured. (Esegue l'override di Task. . :: . .Validate(Connections, VariableDispenser, IDTSComponentEvents, IDTSLogging).) |
In alto
Proprietà
Nome | Descrizione | |
---|---|---|
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. (Esegue l'override di 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. (Ereditato da Task). |
In alto
Vedere anche