Udostępnij za pośrednictwem


sp_changedynamicsnapshot_job (języka Transact-SQL)

Modyfikuje zadanie agent generuje migawka subskrypcja do publikacja z sparametryzowany filtr wierszy.Ta procedura składowana jest wykonywany na Wydawca na bazie publikacja.

Ikona łącza do tematuKonwencje składni Transact-SQL

Składnia

sp_changedynamicsnapshot_job [ @publication = ] 'publication'
    [ , [ @dynamic_snapshot_jobname = ] 'dynamic_snapshot_jobname' ]
    [ , [ @dynamic_snapshot_jobid = ] 'dynamic_snapshot_jobid' ]
    [ , [ @frequency_type = ] frequency_type ] 
    [ , [ @frequency_interval = ] frequency_interval ] 
    [ , [ @frequency_subday = ] frequency_subday ] 
    [ , [ @frequency_subday_interval = ] frequency_subday_interval ] 
    [ , [ @frequency_relative_interval = ] frequency_relative_interval ] 
    [ , [ @frequency_recurrence_factor = ] frequency_recurrence_factor ] 
    [ , [ @active_start_date = ] active_start_date ] 
    [ , [ @active_end_date = ] active_end_date ] 
    [ , [ @active_start_time_of_day = ] active_start_time_of_day ] 
    [ , [ @active_end_time_of_day = ] active_end_time_of_day ] 
    [ , [ @job_login = ] 'job_login' ] 
    [ , [ @job_password = ] 'job_password' ] 

Argumenty

  • [ @ publikacja = 'publication"
    Is the name of the publication.publication is sysname, with no default.

  • [ @ dynamic_snapshot_jobname = 'dynamic_snapshot_jobname"
    Is the name of the snapshot job being changed.dynamic_snapshot_jobnameis sysname, with default value of N'%'.Jeśli dynamic_snapshot_jobid jest określony, należy użyć wartości domyślnej dla dynamic_snapshot_jobname.

  • [ @ dynamic_snapshot_jobid = 'dynamic_snapshot_jobid"
    Is the ID of the snapshot job being changed.dynamic_snapshot_jobid is uniqueidentifier, with default value of NULL.If dynamic_snapshot_jobnameis specified, you must use the default value for dynamic_snapshot_jobid.

  • [ @ frequency_type = frequency_type
    Is the frequency with which to schedule the agent.frequency_type is int, and can be one of the following values.

    Wartość

    Opis

    1

    Jedenczas

    2

    Na żądanie

    4

    Dzienny

    8

    Tygodniowy

    16

    Miesięczne

    32

    Miesięczne względna

    64

    Autostart

    128

    Cykliczne

    NULL(default)

     

  • [ @ frequency_interval = frequency_interval
    The days that the agent runs.frequency_interval is int, and can be one of the following values.

    Wartość

    Opis

    1

    Niedziela

    2

    Poniedziałek

    3

    Wtorek

    4

    Środa

    5

    Czwartek

    6

    Piątek

    7

    Sobota

    8

    Dzień

    9

    Dni powszednie

    10

    Dni weekendowe

    NULL(default)

     

  • [ @ frequency_subday = frequency_subday
    Is how often to reschedule during the defined period.frequency_subday is int, and can be one of the following values.

    Wartość

    Opis

    1

    Raz

    2

    Drugie

    4

    Minuta

    8

    Godziny

    NULL(default)

     

  • [ @ frequency_subday_interval = frequency_subday_interval
    Is the interval for frequency_subday.frequency_subday_interval is int, with a default of NULL.

  • [ @ frequency_relative_interval = frequency_relative_interval
    Jest data scalić Agent jest uruchamiany.This parameter is used when frequency_type is set to 32 (monthly relative).frequency_relative_interval is int, and can be one of the following values.

    Wartość

    Opis

    1

    First

    2

    Drugie

    4

    Trzecia

    8

    Czwarty

    16

    Last

    NULL(default)

     

  • [ @ frequency_recurrence_factor = frequency_recurrence_factor
    Is the recurrence factor used by frequency_type.frequency_recurrence_factor is int, with a default of NULL.

  • [ @ active_start_date = active_start_date
    Is the date when the Merge Agent is first scheduled, formatted as YYYYMMDD.active_start_date is int, with a default of NULL.

  • [ @ active_end_date = active_end_date
    Is the date when the Merge Agent stops being scheduled, formatted as YYYYMMDD.active_end_date is int, with a default of NULL.

  • [ @ active_start_time_of_day = active_start_time_of_day
    Is the time of day when the Merge Agent is first scheduled, formatted as HHMMSS.active_start_time_of_day is int, with a default of NULL.

  • [ @ active_end_time_of_day = active_end_time_of_day
    Is the time of day when the Merge Agent stops being scheduled, formatted as HHMMSS.active_end_time_of_day is int, with a default of NULL.

  • [ @job_login= ] 'job_login'
    Is the Microsoft Windows Account under which the Snapshot Agent runs when generating the snapshot for a subscription using a parameterized row filter.job_login is nvarchar(257), with a default value of NULL.

  • [ @job_password= ] 'job_password'
    Is the password for the Windows Account under which the Snapshot Agent runs when generating the snapshot for a subscription using a parameterized row filter.job_password is nvarchar(257), with a default value of NULL.

    Uwaga dotycząca zabezpieczeńUwaga dotycząca zabezpieczeń

    Jeśli to możliwe, monitują użytkowników o wprowadzenie poświadczenia zabezpieczeń w czasie wykonywania.Jeśli poświadczenia muszą być przechowywane w pliku skryptu, należy zabezpieczyć plik, aby uniemożliwić nieautoryzowany dostęp.

Wartości kodów powrotnych

0 (sukces) lub 1 (błąd)

Uwagi

sp_changedynamicsnapshot_job jest wykorzystywany w replikacja scalająca publikacji z parametrami wiersza filtrów.

Po zmianie agent logowania lub hasła, należy zatrzymać i ponownie uruchomić agenta, zanim zmiana zostanie uwzględniona.

Uprawnienia

Tylko członkowie sysadmin stała rola serwera lub db_owner ustaloną rola bazy danych można wykonać sp_changedynamicsnapshot_job.