After you start an activity-based automation, you may want to add or remove subscribers, or give your subscribers more control over which automation emails they receive.
In this article, you'll learn how to view subscribers in an automation queue, change an automation's recipients, and add a merge tag to your campaigns or automated emails so subscribers can choose to join or leave a automation.
EXEC sp_addlogreader_agent @job_login = @login, @job_password = @password, -- Explicitly specify the use of Windows Integrated Authentication (default) -- when connecting to the Publisher.
@publisher_security_mode = 1; -- Create a transactional publication that supports immediate updating, -- queued updating, and pull subscriptions.
Specify the mode for updatable subscriptions using the New Subscription Wizard.For example, you want existing subscribers to receive an automation, but your trigger is list signup.You can add subscribers to any activity-based automation, except ones that are in a draft state.-- To avoid storing the login and password in the script file, the values -- are passed into SQLCMD as scripting variables.For information about -- how to use scripting variables on the command line and in SQL Server -- Management Studio, see the "Executing Replication Scripts" section in -- the topic "Programming Replication Using System Stored Procedures".