Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Failing agent job Expand / Collapse
Author
Message
Posted Thursday, June 27, 2013 10:26 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, May 12, 2014 7:10 AM
Points: 151, Visits: 283
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
Post #1468253
Posted Thursday, June 27, 2013 10:39 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 8:41 PM
Points: 31,080, Visits: 15,525
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: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1468259
Posted Sunday, June 30, 2013 12:46 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Saturday, September 27, 2014 12:10 PM
Points: 198, Visits: 733

...almost identical code...
When I run it directly...


What exactly do you mean by these two points?
Post your "almost identical" code too.
Post #1468847
Posted Tuesday, July 9, 2013 5:03 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, May 12, 2014 7:10 AM
Points: 151, Visits: 283
Thanks for the help, recreated the agent task as a different user and it worked fine.

Cheers for the help.
Post #1471538
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse