SQL server job failed due to primary key constraint but succeeded in next run without any fix

Copper Contributor

SQL server job failed with primary key constraint issue. When looked into the source, there are no duplicates on primary key. I re ran the job without doing any fix in the next 10 mins. Job got succeeded with no issues. Any idea why it would have happened?

1 Reply

@DevzS Could you bring us more info? Is related to SQL Replication?