Database Mail XPs

To enable 'Database Mail XPs'
Scripts:
sp_configure 'show advanced options', 1;
GO
RECONFIGURE;
GO
sp_configure 'Database Mail XPs', 1;
GO
RECONFIGURE
GO

REINDEXING - UPDATE STATS

ALTER PROCEDURE P_ReIndexDatabases_UpdateStats
AS
Declare @sql varchar(max)
DECLARE @MyTable VARCHAR(255)
DECLARE myCursor
CURSOR FOR
SELECT TABLE_NAME
FROM information_schema.tables
WHERE table_type = 'base table'
OPEN myCursor
FETCH NEXT
FROM myCursor INTO @MyTable
WHILE @@FETCH_STATUS = 0
BEGIN
PRINT 'Reindexing Table: ' + @MyTable
SET @sql='ALTER INDEX ALL ON ['+ @MyTable +'] REBUILD WITH (ONLINE=ON)'
--PRINT @SQL
EXEC (@SQL)
FETCH NEXT
FROM myCursor INTO @MyTable
END
CLOSE myCursor
DEALLOCATE myCursor
EXEC sp_updatestats