Aracılığıyla paylaş

  • Makale

Publication.StartSnapshotGenerationAgentJob Yöntemi

İçin ilk anlık görüntü oluşturur bir iş yayın.

Ad Alanı:  Microsoft.SqlServer.Replication
Derleme:  Microsoft.SqlServer.Rmo (Microsoft.SqlServer.Rmo içinde.dll)

Sözdizimi

'Bildirim
Public Sub StartSnapshotGenerationAgentJob
'Kullanım
Dim instance As Publication

instance.StartSnapshotGenerationAgentJob()

public void StartSnapshotGenerationAgentJob()

public:
void StartSnapshotGenerationAgentJob()

member StartSnapshotGenerationAgentJob : unit -> unit 

public function StartSnapshotGenerationAgentJob()

Kural dışı durumlar

Özel durum Koşul
ApplicationException

The server is not running Microsoft SQL Server 2005 or later, or the publication does not exist on the server.

Açıklamalar

StartSnapshotGenerationAgentJob yöntem yalnızca adlı üyeleri tarafından sysadmin sabit sunucu rolü yayımcı veya üyeleri tarafından db_owner yayın veritabanı üzerinde sabit veritabanı rolü.

Arama StartSnapshotGenerationAgentJob yürütmek için eşdeğer olduğu sp_startpublication_snapshot (Transact-sql).

StartSnapshotGenerationAgentJob yöntem yalnızca SQL Server 2005 ve sonrası.

Bu ad, sınıf veya üye yalnızca desteklenen sürüm 2.0.net Framework.

Örnekler

           // Set the Publisher, publication database, and publication names.
            string publicationName = "AdvWorksProductTran";
            string publicationDbName = "AdventureWorks2008R2";
            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 = "AdventureWorks2008R2"
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