Favorable
asked on
IndexOptimize Script Failed
I have a scheduled maintenance job that IndexOptimize provided by one of the sql server expert (Ola Hallengren).
The job is scheduled and it succeeded in my other SQL Server Instances except for one of the Instance that return error when the job was run.
Here is the job step.
Schedule Job Step:
EXECUTE dbo.IndexOptimize @Databases = 'USER_DATABASES',
@FragmentationLow = NULL,
@FragmentationMedium = 'INDEX_REORGANIZE,INDEX_RE BUILD_ONLI NE,INDEX_R EBUILD_OFF LINE',
@FragmentationHigh = 'INDEX_REBUILD_ONLINE,INDE X_REBUILD_ OFFLINE',
@FragmentationLevel1 = 5,
@FragmentationLevel2 = 30,
@UpdateStatistics = 'ALL',
@OnlyModifiedStatistics = 'Y',
Error Message:
Executed as user: login\user. ... Version: 9.00.4035.00 Edition: Standard Edition
Procedure: [master].[dbo].[IndexOptim ize] Parameters: @Databases = 'USER_DATABASES',
@FragmentationLow = NULL,
@FragmentationMedium = 'INDEX_REORGANIZE,INDEX_RE BUILD_ONLI NE,INDEX_R EBUILD_OFF LINE',
@FragmentationHigh = 'INDEX_REBUILD_ONLINE,INDE X_REBUILD_ OFFLINE',
@FragmentationLevel1 = 5, @FragmentationLevel2 = 30, @PageCountLevel = 1000, @SortInTempdb = 'N', @MaxDOP = NULL,
@FillFactor = NULL, @PadIndex DateTime: 2012-03-17 01:00:00
Database: [mydatabase]
Status: ONLINE
Mirroring role: N/A
Standby: No
Updateability: READ_WRITE User access: MULTI_USER Is accessible: Yes
Recovery model: FULL [SQLSTATE 01000] (Message 50000) DateTime: 2012-03-17 01:00:01
Command: UPDATE STATISTICS [eradicate].[dbo].[benefit ] [_WA_Sys_00000002_060DEAE8 ] [SQLSTATE 01000] (Message 50000) Outcome: Succeeded
Duration: 00:00:00
DateTime: 2012-03-17 01:00:01 [SQLSTATE 01000] (Message 50000) DateTime: 2012-03-1... The step failed.
The job is scheduled and it succeeded in my other SQL Server Instances except for one of the Instance that return error when the job was run.
Here is the job step.
Schedule Job Step:
EXECUTE dbo.IndexOptimize @Databases = 'USER_DATABASES',
@FragmentationLow = NULL,
@FragmentationMedium = 'INDEX_REORGANIZE,INDEX_RE
@FragmentationHigh = 'INDEX_REBUILD_ONLINE,INDE
@FragmentationLevel1 = 5,
@FragmentationLevel2 = 30,
@UpdateStatistics = 'ALL',
@OnlyModifiedStatistics = 'Y',
Error Message:
Executed as user: login\user. ... Version: 9.00.4035.00 Edition: Standard Edition
Procedure: [master].[dbo].[IndexOptim
@FragmentationLow = NULL,
@FragmentationMedium = 'INDEX_REORGANIZE,INDEX_RE
@FragmentationHigh = 'INDEX_REBUILD_ONLINE,INDE
@FragmentationLevel1 = 5, @FragmentationLevel2 = 30, @PageCountLevel = 1000, @SortInTempdb = 'N', @MaxDOP = NULL,
@FillFactor = NULL, @PadIndex DateTime: 2012-03-17 01:00:00
Database: [mydatabase]
Status: ONLINE
Mirroring role: N/A
Standby: No
Updateability: READ_WRITE User access: MULTI_USER Is accessible: Yes
Recovery model: FULL [SQLSTATE 01000] (Message 50000) DateTime: 2012-03-17 01:00:01
Command: UPDATE STATISTICS [eradicate].[dbo].[benefit
Duration: 00:00:00
DateTime: 2012-03-17 01:00:01 [SQLSTATE 01000] (Message 50000) DateTime: 2012-03-1... The step failed.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER