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.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 error in job

Author  Topic 

DBA007
Posting Yak Master

145 Posts

Posted - 2010-06-29 : 06:23:43
Team,
one of my job has failed with below error,this job contains an execution statement of a procedure,the same procedure is been executed in different dbs.

Null value is eliminated by an aggregate or other
SET operation. [SQLSTATE 01003] (Message 8153)
Invalid object name 'accExchangeItemCSF'.
[SQLSTATE 42S02] (Error 208).
The step failed.

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2010-06-29 : 07:27:06
looks like this is ok
Null value is eliminated by an aggregate or other SET operation.

But this:
Invalid object name 'accExchangeItemCSF'. [SQLSTATE 42S02] (Error 208).
should give you an idea...


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page
   

- Advertisement -