July 11, 2012 at 8:46 am
We have scheduled job that executes fine but produces duplicate records (some dupes not all).
When we run this job manually, it produces the correct records no dupes.
What can we look for?
July 11, 2012 at 1:19 pm
We really need to see the query to see what it does to have any idea. Without that information all we can do is throw guesses out there.
One guess is that the job is running at the same time that another process is inserting/updating data and that causes the dupes.
Another is that the source data has dupes in it sometimes.
IF you really don't want dupes and the business rules say that you shouldn't have dupes you should create a unique constraint on the column(s) that define uniqueness so that the job errors out instead of creating the duplicates.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
July 11, 2012 at 1:31 pm
Thanks Jack..
My guess is another job(s) running...
We are checking now...but we wondered if it could be anything else.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply