مشاركة عبر

  • مقالة

Publication.SnapshotJobId Property

Gets the Snapshot Agent job ID for the current publication.

Namespace:  Microsoft.SqlServer.Replication
Assembly:  Microsoft.SqlServer.Rmo (in Microsoft.SqlServer.Rmo.dll)

Syntax

'Declaration
Public ReadOnly Property SnapshotJobId As String
    Get
'Usage
Dim instance As Publication
Dim value As String

value = instance.SnapshotJobId

public string SnapshotJobId { get; }

public:
property String^ SnapshotJobId {
    String^ get ();
}

member SnapshotJobId : string

function get SnapshotJobId () : String

Property Value

Type: System.String
A String value that represents a unique identifier.

Remarks

The SnapshotJobId property can only be retrieved by members of the sysadmin fixed server role at the Publisher, by members of the db_owner fixed database role on the publication database, or by users in the publication access list (PAL).

Retrieving the SnapshotJobId property is equivalent to executing sp_helppublication (Transact-SQL) or sp_helpmergepublication (Transact-SQL).

The SnapshotJobId property is available with SQL Server 7.0, SQL Server 2000, and SQL Server 2005.