Job Can not execute an Update Statement

From: Joe (
Date: 02/04/03

From: "Joe" <>
Date: Tue, 4 Feb 2003 13:44:34 -0800


I have a job, say job_A with one step executing a sp, say
exec p_abc. There is an update statement in the p_abc. I
can run the p_abc in query window with the update
statement and I can run job_A if I comment out the update
statement in the p_abc. However, the job fails whenever
there is (are) some record(s) needed to be update. I have
selected the owner of job_A as sa and the login name of
dbo in the database is sa. Could you help me with this
problem? Thank you