I schedule this proicedure to run 6 Am and there is another job on another machine which runs about 5 Am and completed around 5:15 and feed Data to this procedure. The frequency of the procedure is once in a day. I dont know why its gives me Locks and User error?. Some day its runs fine. Thanks fro your time.