Publication.StartSnapshotGenerationAgentJob Publication.StartSnapshotGenerationAgentJob Publication.StartSnapshotGenerationAgentJob Method

정의

게시에 대한 초기 스냅숏을 생성하는 작업을 시작합니다. Starts the job that generates the initial snapshot for the publication.

public:
 void StartSnapshotGenerationAgentJob();
public void StartSnapshotGenerationAgentJob ();
Public Sub StartSnapshotGenerationAgentJob ()
예외

서버는 실행 되 고 있지 Microsoft SQL Server 2005 이상 또는 게시는 서버에 존재 하지 않습니다. The server is not running Microsoft SQL Server 2005 or later, or the publication does not exist on the server.

예제

// Set the Publisher, publication database, and publication names.
string publicationName = "AdvWorksProductTran";
string publicationDbName = "AdventureWorks2012";
string publisherName = publisherInstance;

TransPublication publication;

// Create a connection to the Publisher using Windows Authentication.
ServerConnection conn;
conn = new ServerConnection(publisherName);

try
{
	// Connect to the Publisher.
	conn.Connect();

	// Set the required properties for an existing publication.
	publication = new TransPublication();
	publication.ConnectionContext = conn;
	publication.Name = publicationName;
	publication.DatabaseName = publicationDbName;

	if (publication.LoadProperties())
	{
		// Start the Snapshot Agent job for the publication.
		publication.StartSnapshotGenerationAgentJob();
	}
	else
	{
		throw new ApplicationException(String.Format(
			"The {0} publication does not exist.", publicationName));
	}
}
catch (Exception ex)
{
	// Implement custom application error handling here.
	throw new ApplicationException(String.Format(
		"A snapshot could not be generated for the {0} publication."
		, publicationName), ex);
}
finally
{
	conn.Disconnect();
}
' Set the Publisher, publication database, and publication names.
Dim publicationName As String = "AdvWorksProductTran"
Dim publicationDbName As String = "AdventureWorks2012"
Dim publisherName As String = publisherInstance

Dim publication As TransPublication

' Create a connection to the Publisher using Windows Authentication.
Dim conn As ServerConnection
conn = New ServerConnection(publisherName)

Try
    ' Connect to the Publisher.
    conn.Connect()

    ' Set the required properties for an existing publication.
    publication = New TransPublication()
    publication.ConnectionContext = conn
    publication.Name = publicationName
    publication.DatabaseName = publicationDbName

    If publication.LoadProperties() Then
        ' Start the Snapshot Agent job for the publication.
        publication.StartSnapshotGenerationAgentJob()
    Else
        Throw New ApplicationException(String.Format( _
         "The {0} publication does not exist.", publicationName))
    End If
Catch ex As Exception
    ' Implement custom application error handling here.
    Throw New ApplicationException(String.Format( _
     "A snapshot could not be generated for the {0} publication." _
     , publicationName), ex)
Finally
    conn.Disconnect()
End Try

설명

StartSnapshotGenerationAgentJob 메서드의 구성원만 호출할 수는 sysadmin 고정된 서버 역할의 멤버 또는 게시자에는 db_owner 게시 데이터베이스의 고정된 데이터베이스 역할입니다.The StartSnapshotGenerationAgentJob method can only be called by members of the sysadmin fixed server role at the Publisher or by members of the db_owner fixed database role on the publication database.

호출 StartSnapshotGenerationAgentJob 를 실행 하는 것과 같습니다 sp_startpublication_snapshot (Transact SQL)합니다.Calling StartSnapshotGenerationAgentJob is equivalent to executing sp_startpublication_snapshot (Transact-SQL).

적용 대상

추가 정보