February 18, 2009 at 11:16 am
Hi...I am having a job that calls the other job in different Server with the help of servername.msdb.dbo.sp_start_job. That job actually calls a stored procedure.The job actually starts executing and Every night I am getting the error like :
Executed as user: Name\LoginName. Invalid object name 'tlcspifitems'. [SQLSTATE 42S02] (Error 208). The step failed.
I have to run the job manually again....does anyone know the cause of the error? Please help me out....
Thank you
February 18, 2009 at 12:28 pm
ssismaddy (2/18/2009)[/b
Executed as user: Name\LoginName. Invalid object name 'tlcspifitems'. [SQLSTATE 42S02] (Error 208). The step failed.
Well, it says its an invalid object name. Have you checked whether the object has been altered/deleted or anything like that?
February 18, 2009 at 12:30 pm
Thanks for the reply....
That object exists in the database....
February 18, 2009 at 12:38 pm
Looks like your job account on that step does not have the right permissions to access such object!
* Noel
February 18, 2009 at 12:45 pm
Would you be able to provide more information on the error you are receiving? Check your Error log and can you provide the deatails?
February 18, 2009 at 12:52 pm
may be u r right neol...It should be access problem....I will change the owner name and the table name to dbo.tablename ....I will check tonight if it is gonna be success...
I couldn't get any more detail error message from error logs...This is all what I have....
Thank you ....
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply