Job Can not execute an Update Statement

From: Joe (joezfeng@yahoo.com)
Date: 02/04/03


From: "Joe" <joezfeng@yahoo.com>
Date: Tue, 4 Feb 2003 13:44:34 -0800


Hi,

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