PHISSUG

Have this error and i have not encounter this before;

JOB po ito, and it running sya for almost a year now, just today i have this error.

Invalid object name 'ZodiacSubscribers'. [SQLSTATE 42S02] (Error 208)  Associated statement is not prepared [SQLSTATE HY007] (Error 0)  Invalid object name 'ZodiacSubscribers'. [SQLSTATE 42S02] (Error 208).  The step failed.

i executed the sp in query analyzer and it worked well.

any feedback? soonest. thanks in advance

no updates or changes made to the databse recently that i know. only daily restarts that are scheduled at 4 am. the error occured yesterday around 7 pm. since the jo is reccuring, the error message are same up to now. the object is a table and yep, it exists. no applicaiton attached to this, i populate one table and the stored procedure will run every 5 mins to get all data and update changes to different tables like -- ZodiacSubscribers.

any idea what might caused this?

thanks.

the job account is under administrator and the sp is under user with permission to add and write data as well as execute. how come it worked before and failed now.

im seing the possibility that the table Zodiac has different owner than that is declared in the sp - i mean they call it aaa.Zodiac when it should be bbb.Zodiac. I'll double check all dependencies on sp and tables.

Im not in the office now,  i'll try it later nalang. heheh. thanks.

if you find something else, please add it here. i will inform you what's the result also.

thanks a lot.

problem solved. i don't what did it. it might be the change on sp - table ownership dependencies. or probably, i already capture the number to unsubscribe from zodiac while running it manually. unfortunately, i cannot recreate the problem to test which solved it. thanks man.