Sql-server – Post replication powershell script – on subscriber

replicationsql serversql-server-2008

I need to execute a command before a replication executes on the publisher, and after, on the subscriber.

I seem to have it working on the publisher, by adding another step in the replication agent.

But i have yet to discover how i can execute another step on the subscriber.
I't has to be possible to somehow trigger a job on the subscriber, after a replication has succeded.

Do anyone know how this can be done?

Best Answer

Add another job step to the snapshot agent which runs sqlcmd with what ever T-SQL command needs to be run using the -S parameter to specify to connect to the remote SQL Server.

Related Question