REBUILD INDEXES JOB FAILS
-
hi, i have a weekly job that rebuilds my indexes, for the past two weeks the job has been failing with the errror:
Executed as user: domain\serviceaccount. Cannot find index 'IX_ddr_BI_EmployeesDIM'. [SQLSTATE 42S21] (Error 2727). The step failed.
I have double checked the index exists.
When i invoke the job manually it succeeds.
The job rebuilds indexes via a stored procedure.
please help.
-
Could you check if there is any other job thta may be rebuilding the indexes at the same time. You can try changing the schedule for the job. I had something like that on a SCOM database.
-
Just check if the job is pointing to the correct database.
-
Check to see if there are other jobs with that same service account that are failing or if anything else uses that account where the permissions could have changed at the domain level. If it is the same service account on the domain as the service, then not the issue. When you manually invoke the procedure, try to log in with the credentials as the service account using sql authentication instead of windows.
-
matt.newman (10/12/2011)
Check to see if there are other jobs with that same service account that are failing or if anything else uses that account where the permissions could have changed at the domain level. If it is the same service account on the domain as the service, then not the issue. When you manually invoke the procedure, try to log in with the credentials as the service account using sql authentication instead of windows.I agree with Matt. please check with permissions
Sagar Sonawane
** Every DBA has his day!!:cool: -
Thank you all.
-
THE-FHA (10/12/2011)
Thank you all.Could you please let us know what was causing the problem? Thanks in advance. 🙂
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply