[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1495
  • Last Modified:

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_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE',
@FragmentationHigh = 'INDEX_REBUILD_ONLINE,INDEX_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].[IndexOptimize]  Parameters: @Databases = 'USER_DATABASES',
@FragmentationLow = NULL,
@FragmentationMedium = 'INDEX_REORGANIZE,INDEX_REBUILD_ONLINE,INDEX_REBUILD_OFFLINE',
@FragmentationHigh = 'INDEX_REBUILD_ONLINE,INDEX_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.
0
Favorable
Asked:
Favorable
1 Solution
 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
The error message does tell much as part of job error output.  Please run the IndexOptimize manually to get a more complete error message.
0
 
FavorableAuthor Commented:
I eventually added an output location.
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now