If I understand you correctly, what you are looking for can be accomplished by editing the job steps from Enterprise Manager. Under the Advanced tab, you can dictate whether...

If the record with the duplicate primary key is an exact duplicate you could add an INSTEAD of INSERT trigger.

This solution checks the main table for matching primary keys in...