Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
rubs_65
Posting Yak Master
144 Posts |
 Posted - 2004-11-24 : 14:17:17
|
| Hi,We have a procedure that loops over all tables and indexed views and update statistics with fullscan. When we run from QA it works fine but when we run this as a job using sqlagent it fails without giving much error and always for some adhoc table. What can be the possible reason?Thanks--Harvinder |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2004-11-24 : 18:55:45
|
| Maybe the table isn't owned by dbo and your process doesn't include the user in the command?==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-11-25 : 02:49:17
|
| check if the job owner has enough permission to perform what the procedure was designed to do.you could also post the error message--------------------keeping it simple... |
|
|
|
|
|
|
sqlagent job issue