Reindex and Update Statistics Daily Job failing v2012
Symptoms
Reindex and Update Statistics Daily job failing with the following error:
Error/warning messages
04/11/2013 14:24:07,Changepoint_UAT_Reindex and Update Statistics daily,Error,1,CSTCOLOSQL01,Changepoint_UAT_Reindex and Update Statistics daily,Daily Reindex,,Executed as user: CSTECH\sqlserversvs. Cannot drop the table 'ReindexList' because it does not exist or you do not have permission. [SQLSTATE 42S02] (Error 3701) DBCC execution completed. If DBCC printed error messages contact your system administrator. [SQLSTATE 01000] (Error 2528). The step failed.,00:00:04,11,2528,,,,0
Reason
User that created the 'ReindexList' table did not have dbo access.
Resolution
The following resolved the issue:
1. Deleted the table (tablename\username.ReindexList)
2. Added dbo as the default schema as follows:
• Go to Security, expand Logins
• Click the user, right click and select properties
• Click on User Mappings and select db_owner for the default schema.
• Click ok.