Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2002
    Greenville, SC

    Unanswered: Stored procedure will run to completion within query analyzer but not as a sql job

    One of our developers has a stored procedure that updates records. When he runs it within query analyzer it runs to completion even though it gives some duplicate record errors. When it is run as a job it fails on the first duplicate record error. Is there a way to make the procedure run like it does in query analyzer as a job.


  2. #2
    Join Date
    Jul 2002
    I have had the same problem and do not understand what causes it but the problem can be solved by using the keyword DISTINCT in the SELECTS that return duplicate rows. This should be a quick easy fix.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts