February 11, 2011 at 1:36 pm
I have a procedure which executes to completion when run in Query Analyzer. If the procedure is run as a job, it starts executing but stops /hangs after the 10th record is inserted. At this point there are 8 errors which were trapped and corrected during the processing. The log shows up to the fetch of the 10th record and then nothing. After the fetch, I would expect to see either an insert or constraint error due to duplicate key.
Any suggestions would be helpful. I don't think it's a security issue since the job does get into the procedure a good bit before it hangs.
Thanks!
Anne
February 11, 2011 at 3:12 pm
Can you supply the exact error message from the Log File Viewer?
Chris Powell
George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.
February 22, 2011 at 6:39 am
There were no errors reported anywhere. We figured maybe the agent overall could trap so many errors and then just stop? At my suggestion the developer adjusted the logic of the job to first delete the prior records (this is an intermediate load table) and then insert. This worked successfully.
Anne
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply