sp_changedynamicsnapshot_job (Transact-SQL)

Modyfikuje zadanie agenta, które generuje migawka subskrypcja na publikacja w sieci przy użyciu sparametryzowany filtr wierszy.Ta procedura przechowywana jest wykonywana przez wydawcę na baza danych publikacja.

Konwencje składni języka Transact-SQL

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

• [ @publication = ] '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'%'.If dynamic_snapshot_jobid is specified, you must use the default value for 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ść	Description
  1	Jeden raz
  2	Na żądanie
  4	Dzienne
  8	Co tydzień
  16	Miesięczne
  32	Względna miesięczne
  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ść	Description
  1	Niedziela
  2	Poniedziałek
  3	Wtorek
  4	Środa
  5	Czwartek
  6	Piątek
  7	Sobota
  8	Dzień
  9	Dni tygodnia
  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ść	Description
  1	Tylko raz
  2	Sekundy
  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 to data działającą Agent korespondencji seryjnej.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ść	Description
  1	First
  2	Sekundy
  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.

  Security Note:
  Jeśli jest to możliwe, monituje 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 (brak)

Remarks

sp_changedynamicsnapshot_job jest używany w replikacja łączenia do publikacji z filtrami parametrami wiersza.

Po zmianie programu agent logowania lub hasła, Zatrzymaj i ponownie uruchomić agenta, zanim zmiana ma wpływ.

Uprawnienia

Tylko członkowie sysadmin Rola serwera lub db_owner stała rola bazy danych mogą być wykonać sp_changedynamicsnapshot_job.

See Also

Other Resources

Jak Umożliwia wyświetlanie i modyfikowanie ustawień zabezpieczeń replikacja (replikacja programowania języka Transact-SQL)

Migawki publikacji korespondencji seryjnej z filtrami sparametryzowana