• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 227
  • Last Modified:

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.
0
canuckconsulting
Asked:
canuckconsulting
  • 2
  • 2
1 Solution
 
David ToddSenior DBACommented:
Hi,

If you check, I'm pretty sure that replication is implemented as a SQL Agent job.

So if you start the job(s) that have the replication things in them, then you start the replication.
http://msdn.microsoft.com/en-us/library/ms186757.aspx

HTH
  David
0
 
canuckconsultingAuthor Commented:
Thanks David.

The problem is these jobs are on another server.  Is there a way for me to kick a job off on a remote server?
0
 
David ToddSenior DBACommented:
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.dbo.sp_StartJob

The procedure may be in msdb or master databases.

HTH
  David
0
 
canuckconsultingAuthor Commented:
Thanks David.   I did look at the link and completely missed the server parameter.  Cheers for the help!
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now