I am trying to set up a SQL Job to run 5 different Push Sync's to my Re-Publishing Servers. To be clear, I have 4 Re-Publishers and each of those has 5 different Replication Sets. I created a Job that seems to kick off a Sync for each of the 5 Sets on a single server but the Job reports failure every time. Below is the Creation Script for that Job. I modeled it after the individual Replication Jobs that are created when you create a publication.

Is there a better or simpler way of doing this? If not, what am I doing wrong? Thanks for any time spent. alt text

link|improve this question

What's the error the job reports on failure? – jl. Nov 17 '10 at 16:26
The last step reports an error no matter what as it is a cleanup. It is suppossed to quit on the second to last step if successful. The ERROR it reports is simply "The Job Failed" – Refracted Paladin Nov 17 '10 at 16:32
feedback

Know someone who can answer? Share a link to this question via email, Google+, Twitter, or Facebook.

Your Answer

 
or
required, but never shown

Browse other questions tagged or ask your own question.