Condividi tramite

TransferJobsTask Members

  • Articolo

Provides the methods and properties to transfer SQL Server Agent jobs from one instance of SQL Server to another.

The following tables list the members exposed by the TransferJobsTask type.

Public Constructors

  Nome Description
TransferJobsTask Initializes a new instance of the TransferJobsTask class.

Torna all'inizio

Public Properties

  Nome Description
ms215245.pubproperty(it-it,SQL.90).gif DebugMode Gets or sets a Boolean indicating whether a task should determine whether breakpoints are enabled.
ms215245.pubproperty(it-it,SQL.90).gif DestinationConnection Gets or sets a String containing the name of the SMO connection manager for the destination database.
ms215245.pubproperty(it-it,SQL.90).gif EnableJobsAtDestination Gets or sets a Boolean indicating whether the jobs created at the destination should be enabled.
ms215245.pubproperty(it-it,SQL.90).gif ExecutionValue Overridden. Returns an object containing the number of jobs transfered.
ms215245.pubproperty(it-it,SQL.90).gif 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.
ms215245.pubproperty(it-it,SQL.90).gif JobsList Gets or sets a StringCollection containing the names of the jobs to transfer.
ms215245.pubproperty(it-it,SQL.90).gif SourceConnection Gets or sets a String containing the name of the SMO connection manager for the source database.
ms215245.pubproperty(it-it,SQL.90).gif 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.
ms215245.pubproperty(it-it,SQL.90).gif TransferAllJobs Gets or sets a Boolean indicating if some or all jobs are transferred.
ms215245.pubproperty(it-it,SQL.90).gif Version  Returns the version of the task. This property is read-only. (inherited from Task)
ms215245.pubproperty(it-it,SQL.90).gif WaitForMe  Returns a Boolean that indicates whether the parent container should wait for completion of this task. This property is read-only. (inherited from Task)

Torna all'inizio

Public Methods

(see also Protected Methods )

  Nome Description
ms215245.pubmethod(it-it,SQL.90).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.
ms215245.pubmethod(it-it,SQL.90).gif CanUpdate  (inherited from Task )
ms215245.pubmethod(it-it,SQL.90).gif Equals  Overloaded. (inherited from DtsObject )
ms215245.pubmethod(it-it,SQL.90).gif Execute Overridden. Runs the task.
ms215245.pubmethod(it-it,SQL.90).gif GetConnectionID  (inherited from Task )
ms215245.pubmethod(it-it,SQL.90).gif GetConnectionName  (inherited from Task )
ms215245.pubmethod(it-it,SQL.90).gif GetHashCode  Returns the hash code for this instance. (inherited from DtsObject)
ms215245.pubmethod(it-it,SQL.90).gif GetType  (inherited from Object )
ms215245.pubmethod(it-it,SQL.90).gif InitializeTask Overridden. Initializes the properties associated with the task. This method is called by the runtime and is not used in code.
ms215245.pubmethod(it-it,SQL.90).gif LoadFromXML This method is not callable by your application code. To load a package saved as .xml, use the Application.LoadPackage method.
ms215245.pubmethod(it-it,SQL.90).gifms215245.static(it-it,SQL.90).gif op_Equality  (inherited from DtsObject )
ms215245.pubmethod(it-it,SQL.90).gifms215245.static(it-it,SQL.90).gif op_Inequality  (inherited from DtsObject )
ms215245.pubmethod(it-it,SQL.90).gifms215245.static(it-it,SQL.90).gif ReferenceEquals  (inherited from Object )
ms215245.pubmethod(it-it,SQL.90).gif ResumeExecution Resumes execution of the task after pausing. The task or container is resumed by the run-time engine.
ms215245.pubmethod(it-it,SQL.90).gif SaveToXML This method is not callable by your application code. To save a package as .xml, use the Application.SaveToXml method.
ms215245.pubmethod(it-it,SQL.90).gif SuspendExecution Indicates that the executable needs to suspend. This method is called by the run-time engine.
ms215245.pubmethod(it-it,SQL.90).gif ToString  (inherited from Object )
ms215245.pubmethod(it-it,SQL.90).gif Update  (inherited from Task )
ms215245.pubmethod(it-it,SQL.90).gif Validate Overridden. Verifies that the task is correctly configured.

Torna all'inizio

Protected Methods

  Nome Description
ms215245.protmethod(it-it,SQL.90).gif Finalize  (inherited from Object )
ms215245.protmethod(it-it,SQL.90).gif MemberwiseClone  (inherited from Object )

Torna all'inizio

Vedere anche

Riferimento

TransferJobsTask Class
Microsoft.SqlServer.Dts.Tasks.TransferJobsTask Namespace