DECLARE @database_name NVARCHAR(50)

SELECT @database_name=DB_NAME()

WHILE 1 = 1

BEGIN

IF EXISTS(

SELECT 1

FROM msdb.dbo.backupmediafamily

INNER JOIN msdb.dbo.backupset ON msdb.dbo.backupmediafamily.media_set_id = msdb.dbo.backupset.media_set_id

WHERE database_name = @database_name and backup_finish_date BETWEEN DATEADD(MINUTE, -10, GETDATE()) AND GETDATE())

BEGIN

ALTER INDEX [CCOUNTDATEVOUCHER] ON [dbo].[DB] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF,

STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = ON );

ALTER INDEX [DATEVOUCHER] ON [dbo].[DB] REBUILD PARTITION = ALL WITH ( PAD_INDEX = OFF,

STATISTICS_NORECOMPUTE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, ONLINE = OFF, SORT_IN_TEMPDB = ON );

BREAK;

END --IF

ELSE

WAITFOR DELAY '00:10:00'

END --WHILE