This one may dumb ...
I have a set of stored procs that do some inserts based on existing data. This works fine.
I created another sp that calls all of those above. Works fine, too.
Now I want this to happen regularly. Created job, run once, everything is fine. Running the job the next time raises an error - there are duplicates on unique indices. I know that - I created the indices ;-) When I run the sp from Query Analyzer, I get warnings but everything is commited. This is exactly what I want - "On Error log the messages somewhere and RESUME, please".