April 22, 2009 at 2:22 pm
thank you! i did a job with the first step to EXEC sp_publication_validation 'pubnaname', @rowcount_only=1 and second step to send notification (stored procedure that check the sysreplicationalerts table for errors).
just to confirm, this job should run from the publisher server against the database that is being published or against the distributor DB? both steps?
April 24, 2009 at 12:15 pm
The job just needs one step to call the sp_validate...
On the subscriber the alert will fire if there are validation errors.
If the alert has notification by email that's all you need.
* Noel
June 11, 2009 at 7:29 am
yes, but the "job" should be in the publisher or the subscriber??. I have it in the publisher and in the job history it says for all my tables expected rowcount value , but when i check my subscriber tables, rowcounts don't match.
i have two steps in my job (in the publication server) to go against my publish Database.
1. EXEC sp_publication_validation 'publicationname'
2. to query the msdb..sysreplicationalerts and if there is an error to send an email (this is in a stored procedure).
does the alert called Replication: Subscriber has failed data validation have to be enabled? I don't see no 20574 error in the msdb..sysreplicationalerts table.
:crying:
Viewing 3 posts - 16 through 17 (of 17 total)
You must be logged in to reply to this topic. Login to reply