sp_addpullsubscription_agent |
#NAMEDEF# |
|---|---|
| SQL Server | |
Syntaxe
|
sp_addpullsubscription_agent [ @publisher = ] 'publisher' [ , [ @publisher_db = ] 'publisher_db' ] , [ @publication = ] 'publication' [ , [ @subscriber = ] 'subscriber' ] [ , [ @subscriber_db = ] 'subscriber_db' ] [ , [ @subscriber_security_mode = ] subscriber_security_mode ] [ , [ @subscriber_login = ] 'subscriber_login' ] [ , [ @subscriber_password = ] 'subscriber_password' ] [ , [ @distributor = ] 'distributor' ] [ , [ @distribution_db = ] 'distribution_db' ] [ , [ @distributor_security_mode = ] distributor_security_mode ] [ , [ @distributor_login = ] 'distributor_login' ] [ , [ @distributor_password = ] 'distributor_password' ] [ , [ @optional_command_line = ] 'optional_command_line' ] [ , [ @frequency_type = ] frequency_type ] [ , [ @frequency_interval = ] frequency_interval ] [ , [ @frequency_relative_interval = ] frequency_relative_interval ] [ , [ @frequency_recurrence_factor = ] frequency_recurrence_factor ] [ , [ @frequency_subday = ] frequency_subday ] [ , [ @frequency_subday_interval = ] frequency_subday_interval ] [ , [ @active_start_time_of_day = ] active_start_time_of_day ] [ , [ @active_end_time_of_day = ] active_end_time_of_day ] [ , [ @active_start_date = ] active_start_date ] [ , [ @active_end_date = ] active_end_date ] [ , [ @distribution_jobid = ] distribution_jobid OUTPUT ] [ , [ @encrypted_distributor_password = ] encrypted_distributor_password ] [ , [ @enabled_for_syncmgr = ] 'enabled_for_syncmgr' ] [ , [ @ftp_address = ] 'ftp_address' ] [ , [ @ftp_port = ] ftp_port ] [ , [ @ftp_login = ] 'ftp_login' ] [ , [ @ftp_password = ] 'ftp_password' ] [ , [ @alt_snapshot_folder = ] 'alternate_snapshot_folder' ] [ , [ @working_directory = ] 'working_directory' ] [ , [ @use_ftp = ] 'use_ftp' ] [ , [ @publication_type = ] publication_type ] [ , [ @dts_package_name = ] 'dts_package_name' ] [ , [ @dts_package_password = ] 'dts_package_password' ] [ , [ @dts_package_location = ] 'dts_package_location' ] [ , [ @reserved = ] 'reserved' ] [ , [ @offloadagent = ] 'remote_agent_activation' ] [ , [ @offloadserver = ] 'remote_agent_server_name'] [ , [ @job_name = ] 'job_name' ] [ , [ @job_login = ] 'job_login' ] [ , [ @job_password = ] 'job_password' ] |
Description
Cette Stored Procedure permet d'ajouter un nouveau travail d'agent planifié utilisé pour synchroniser un abonnement d'extraction à une publication transactionnelle. Cette STORED PROCEDURE est exécutée au niveau de Subscriber sur la base de données d'abonnement.
Dernière mise à jour : Dimanche, le 29 Août 2021