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:
Date27/06/2013 17:23:50
LogJob History (BiblioWeb Merge and FreeTextSearch Update)
Step ID2
ServerSQLVM
Job NameBiblioWeb Merge and FreeTextSearch Update
Step NameFree Text update
Duration00:00:00
Sql Severity16
Sql Message ID208
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0
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.
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