RebuildI ndex job - SQL Server Forums

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

General SQL Server Forums

New to SQL Server Programming

RebuildI ndex job

Author

Topic

laddu
Constraint Violating Yak Guru

332 Posts

Posted - 2008-01-14 : 20:40:54

Rebuild Index job for user db's is failing, one user db is a huge size 120 GB. The job scheduled to run every sunday 1 AM

I found the below error in log report
Rebuild Index Task (server name)
Rebuild index on Local server connection
Databases: All user databases
Object: Tables and views
Original amount of free space
Task start: 01/13/2008 1:26 AM.
Task end: 01/13/2008 2:38 AM.
Failed:(-1073548784) Executing the query "ALTER INDEX [Idx_CISCO_WLC_EVENTID] ON [dbo].[CISCO_WLC_200711262137] REBUILD WITH ( PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, SORT_IN_TEMPDB = OFF, ONLINE = OFF )
" failed with the following error: "Cannot find the object "dbo.CISCO_WLC_200711262137" because it does not exist or you do not have permissions.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2008-01-15 : 02:43:43

Have you doublechecked the dbo.CISCO_WLC_200711262137 object , is it present ? does it have the right permissions?

Jack Vamvas
--------------------
Search IT jobs from multiple sources- http://www.ITjobfeed.com

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-01-20 : 21:15:32

Is it maintenance plan job or job to run your own code?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources