共用方式為


JobCollection Members

The JobCollection class represents a collection of Job objects that represent all the jobs defined on the JobServer object.

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

Protected Fields

  名稱 Description
ms219057.protfield(zh-tw,SQL.90).gif initialized  This value supports the SQL Server Management Objects infrastructure and is not intended to be used directly from your code. (inherited from AbstractCollectionBase)

頂端

Public Properties

  名稱 Description
ms219057.pubproperty(zh-tw,SQL.90).gif Count  Gets the number of objects in the referenced collection. (inherited from SmoCollectionBase)
ms219057.pubproperty(zh-tw,SQL.90).gif IsSynchronized  Gets the Boolean property value that specifies whether access to the collection is synchronized and therefore thread-safe. (inherited from SmoCollectionBase)
ms219057.pubproperty(zh-tw,SQL.90).gif Item  Overloaded. Gets a Job object in the collection by name or by index number. (inherited from JobBaseCollection)
ms219057.pubproperty(zh-tw,SQL.90).gif Parent  Gets the JobServer object that is the parent of the JobCollection object. (inherited from JobBaseCollection)
ms219057.pubproperty(zh-tw,SQL.90).gif SyncRoot  Gets an object that can be used to synchronize access to the collection. (inherited from SmoCollectionBase)

頂端

Public Methods

(see also Protected Methods )

  名稱 Description
ms219057.pubmethod(zh-tw,SQL.90).gif Contains  Determines whether a job with the specified name exists in the collection. (inherited from SimpleObjectCollectionBase)
ms219057.pubmethod(zh-tw,SQL.90).gif CopyTo  Copies the collection objects to a one-dimensional array beginning at the specified index value. (inherited from JobBaseCollection)
ms219057.pubmethod(zh-tw,SQL.90).gif Equals  Overloaded. (inherited from Object )
ms219057.pubmethod(zh-tw,SQL.90).gif GetEnumerator  Returns an IEnumerator interface that allows you to iterate through the objects in the collection. (inherited from SmoCollectionBase)
ms219057.pubmethod(zh-tw,SQL.90).gif GetHashCode  (inherited from Object )
ms219057.pubmethod(zh-tw,SQL.90).gif GetType  (inherited from Object )
ms219057.pubmethod(zh-tw,SQL.90).gif ItemById Gets the Job object that is specified by the Guid ID value.
ms219057.pubmethod(zh-tw,SQL.90).gifms219057.static(zh-tw,SQL.90).gif ReferenceEquals  (inherited from Object )
ms219057.pubmethod(zh-tw,SQL.90).gif Refresh  Overloaded. Refreshes the referenced collection. (inherited from SmoCollectionBase)
ms219057.pubmethod(zh-tw,SQL.90).gif Script  Overloaded. Generates a Transact-SQL script that can be used to re-create the collection Job objects. (inherited from JobBaseCollection)
ms219057.pubmethod(zh-tw,SQL.90).gif ToString  (inherited from Object )

頂端

Protected Methods

  名稱 Description
ms219057.protmethod(zh-tw,SQL.90).gif AddExisting  (inherited from AbstractCollectionBase )
ms219057.protmethod(zh-tw,SQL.90).gif AddImpl  (inherited from SortedListCollectionBase )
ms219057.protmethod(zh-tw,SQL.90).gif Finalize  (inherited from Object )
ms219057.protmethod(zh-tw,SQL.90).gif GetCollectionElementType  Returns the type of object that the collection consists of. (inherited from JobBaseCollection)
ms219057.protmethod(zh-tw,SQL.90).gif GetItemById  Overloaded. (inherited from SmoCollectionBase )
ms219057.protmethod(zh-tw,SQL.90).gif GetObjectByIndex  (inherited from SmoCollectionBase )
ms219057.protmethod(zh-tw,SQL.90).gif ImplAddExisting  (inherited from SortedListCollectionBase )
ms219057.protmethod(zh-tw,SQL.90).gif InitializeChildCollection  Overloaded. Initializes the child collections of the referenced collection. (inherited from SmoCollectionBase)
ms219057.protmethod(zh-tw,SQL.90).gif InitInnerCollection  Initializes the collection. (inherited from SimpleObjectCollectionBase)
ms219057.protmethod(zh-tw,SQL.90).gif MemberwiseClone  (inherited from Object )
ms219057.protmethod(zh-tw,SQL.90).gif ValidateParentObject  (inherited from SmoCollectionBase )

頂端

Explicit Interface Implementations

  名稱 Description
System.Collections.ICollection.CopyTo  (inherited from SmoCollectionBase )

頂端

請參閱

參考

JobCollection Class
Microsoft.SqlServer.Management.Smo.Agent Namespace

其他資源

Using Collections