Job Can not execute an Update Statement
From: Joe (firstname.lastname@example.org)
- Next message: Peter Thelin: "Re: xp_cmdshell"
- Previous message: CD: "SQL Cracking....."
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: "Joe" <email@example.com> 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