Delete log and rebuild index of AsyncOperationBase and WorkflowLogBase table in Dynamics CRM using SQL Job

USE [msdb] GO /****** Object:  Job [Async-CleanUP]    Script Date: 05/27/2010 12:36:09 ******/ BEGIN TRANSACTION DECLARE @ReturnCode INT SELECT @ReturnCode = 0 /****** Object:  JobCategory [[Uncategorized (Local)]]]    Script Date: 05/27/2010 12:36:09 ******/ IF NOT EXISTS (SELECT name FROM msdb.dbo.syscategories WHERE name=N’[Uncategorized (Local)]‘ AND category_class=1) BEGIN EXEC @ReturnCode = msdb.dbo.sp_add_category @class=N’JOB’, @type=N’LOCAL’, @name=N’[Uncategorized (Local)]‘ IF (@@ERROR <> [...]

Rebuild Index of a database table

DECLARE @Database VARCHAR(255) DECLARE @Table VARCHAR(255) DECLARE @cmd NVARCHAR(500) DECLARE @fillfactor INT SET @fillfactor = 90 CREATE Table #databaseName (dbid int identity(1,1), DbName Varchar(255)) Insert into #databaseName SELECT name FROM   MASTER.dbo.sysdatabases –  WHERE  name NOT IN ( ‘master’, ‘model’, ‘msdb’, ‘tempdb’, ‘distrbution’ ) WHERE  name IN ( ‘OD’) ORDER  BY 1 CREATE Table #TableName (Tableid [...]