June 27, 2013 at 10:26 am
Hi,
Strange one bugging me have almost identical code running in another database on the server without issue.
I have an agent job which runs
DELETE FROM [biostratweb].[dbo].[xx_FreeTextSearch_ABS]
However I always get an error:
Date 27/06/2013 17:23:50
Log Job History (BiblioWeb Merge and FreeTextSearch Update)
Step ID 2
Server SQLVM
Job Name BiblioWeb Merge and FreeTextSearch Update
Step Name Free Text update
Duration 00:00:00
Sql Severity 16
Sql Message ID 208
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0
Message
Executed as user: NEFTEX\spsqlagent. Invalid object name 'biostratweb.dbo.xx_FreeTextSearch_ABS'. [SQLSTATE 42S02] (Error 208). The step failed.
When I run it directly it works fine.
Any ideas, I am running SQL 2008.
Many Thanks as always,
Oliver
June 27, 2013 at 10:39 am
I'd guess you have some permissions issue here. With the three part naming, I'd expect that context isn't an issue, but either the object, or the delete permission is missing for the agent service account or that proxy user.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
June 30, 2013 at 12:46 am
...almost identical code...
When I run it directly...
What exactly do you mean by these two points?
Post your "almost identical" code too.
July 9, 2013 at 5:03 am
Thanks for the help, recreated the agent task as a different user and it worked fine.
Cheers for the help.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply