How to kick off replication on a different 2012 SQL Server

Posted on 2014-08-13
Last Modified: 2014-08-14
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.
Question by:canuckconsulting
    LVL 35

    Accepted Solution


    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.


    Author Comment

    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?
    LVL 35

    Expert Comment

    by:David Todd

    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.


    Author Closing Comment

    Thanks David.   I did look at the link and completely missed the server parameter.  Cheers for the help!

    Featured Post

    Gigs: Get Your Project Delivered by an Expert

    Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

    Join & Write a Comment

    Suggested Solutions

    Introduction SQL Server Integration Services can read XML files, that’s known by every BI developer.  (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.) But how far can you go?  When does the XML Source component become …
    In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
    Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now