April 13, 2016 at 8:20 am
Can you kick off a job.. after replication pulls all the data from the publisher to the subscriber?
April 15, 2016 at 8:17 am
I'm not clear what your question is.
"Kick off" what kind of job ??
April 15, 2016 at 8:47 am
What type of replication is it? Transactional, merge etc? What sort of job is it?
You can configure replication to run a script after a snapshot is applied - to do so, go to the publication, right click, go to properties, then go to 'Snapshot'. Under 'Run additional scripts' you can choose a script to run after the snapshot is applied. You can use a T-SQL script to execute a SQL Server Agent job. Is that what you're after?
April 18, 2016 at 2:18 pm
I have not set it up yet.. so the type could be any... what I am looking to do is to kick off a pull, then move forward with all the jobs that will then take the data from the sync'ed tables and move them into summary tables and cubes. The problem that I have.. is that if I kick off a pull using exec.. then it will move on to my next statement.. while the pull is taking place... not AFTER all tables have been updated.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply