Disabled

Skipping nightly processing

EXECUTE master.dbo.IndexOptimize @Databases = , @UpdateStatistics = 'ALL', @OnlyModifiedStatistics='Y', @LogToTable = 'Y'

Weekly Maintenance for #encodeForHTML( _targetDatabaseName )#

#htmleditformat( _r.sql )#

EXECUTE master.dbo.IndexOptimize @Databases = , @FragmentationMedium = 'INDEX_REORGANIZE', @FragmentationHigh = NULL, @FragmentationLevel1 = 10, @FragmentationLevel2 = 50, @UpdateStatistics = 'ALL', @OnlyModifiedStatistics = 'Y', @LogToTable = 'Y'

Nightly Maintenance for #encodeForHTML( _targetDatabaseName )#

#htmleditformat( _r.sql )#

DELETE FROM master.dbo.CommandLog WHERE StartTime < DATEADD(dd,-30,GETDATE()) select getDate() startTime with objectStats as ( select objectName, min( startTime ) firstStart, max( endTime ) lastEnd from master..CommandLog with (nolock) where databaseName = and startTime > group by objectName ) select *, datediff( minute, firstStart, lastEnd ) runningMinutes from objectStats order by runningMinutes desc