asked on How to kick off replication on a different 2012 SQL Server
I have two SQL Servers:
1) DBProduction (SQL Server 2008)
2) DBWarehouse (SQL Server 2012)
On DBProduction I have snapshot replication set up as well as a push subscription which replicates the snapshot from DBProduction to DBWarehouse.
I have a job JOB_Process running on DBWarehouse 2012 which updates a number of tables in DBProduction. What I would like to do is add a final step to JOB_Process which would kick off a new snapshot on DBProduction followed by having the push replication subscription ran.
1) DBProduction (SQL Server 2008)
2) DBWarehouse (SQL Server 2012)
On DBProduction I have snapshot replication set up as well as a push subscription which replicates the snapshot from DBProduction to DBWarehouse.
I have a job JOB_Process running on DBWarehouse 2012 which updates a number of tables in DBProduction. What I would like to do is add a final step to JOB_Process which would kick off a new snapshot on DBProduction followed by having the push replication subscription ran.
Microsoft SQL ServerMicrosoft SQL Server 2008
Last Comment
canuckconsulting
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
Hi,
If you look at that link there the server as a parameter.
Alternatively, use the four part name convention across a linked server
eg Servername.databasename.db
The procedure may be in msdb or master databases.
HTH
David
If you look at that link there the server as a parameter.
Alternatively, use the four part name convention across a linked server
eg Servername.databasename.db
The procedure may be in msdb or master databases.
HTH
David
ASKER
Thanks David. I did look at the link and completely missed the server parameter. Cheers for the help!
The problem is these jobs are on another server. Is there a way for me to kick a job off on a remote server?